OraFAQ Forum: Forms » how can calc net sal of month end

Home » Developer & Programmer » Forms » how can calc net sal of month end

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can calc net sal of month end [message #572774]

Mon, 17 December 2012 09:46

hassan08
Messages: 122
Registered: June 2011
Location: egypt

Senior 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

Report message to a moderator