Home » Developer & Programmer » Forms » how can calc net sal of month end
how can calc net sal of month end [message #572774] Mon, 17 December 2012 09:46 Go to next message
hassan08
Messages: 91
Registered: June 2011
Location: egypt
Member
I have this tables
-----------master----
CREATE TABLE master
(
emp_id NUMBER,
sanction_id NUMBER
)


emp_id fk from other table employees
and table employees structure is
create table employees (
emp_id number(4) primary key,
fixed_salary number(7))
sanction_id fk from table sanctions
and structure sanctions
sanction_id number primary key,
sanction_value number)
----------------------------------------
detailed
create table detailed
(
emp_id number,
sanction_id number,
sanction_name varchar2(200 BYTE),
net_sal number,
sanction_value number,
sanction_date date)
emp_id fk from other table employees
sanction_id fk from table sanctions
----------------------------------------
and make this tables master and detailes from

and i calc the net sal to every employees take sanctions
my probloem i want if month end will calc the fixed salary
not a net sal

Re: how can calc net sal of month end [message #572806 is a reply to message #572774] Mon, 17 December 2012 15:20 Go to previous messageGo to next message
Littlefoot
Messages: 19326
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you saying that - after four months - you still didn't fix that?
Re: how can calc net sal of month end [message #572814 is a reply to message #572806] Mon, 17 December 2012 17:40 Go to previous messageGo to next message
hassan08
Messages: 91
Registered: June 2011
Location: egypt
Member
yes i still didn't fix that can attach the dmp and fmb
Re: how can calc net sal of month end [message #572867 is a reply to message #572814] Tue, 18 December 2012 05:56 Go to previous message
hassan08
Messages: 91
Registered: June 2011
Location: egypt
Member
pls somebody can help me
Previous Topic: Forms 6i Crashes when Omitt Optional Parameters
Next Topic: trigger when validate item
Goto Forum:
  


Current Time: Tue Jul 29 10:39:48 CDT 2014

Total time taken to generate the page: 0.12071 seconds