[Home] [Help]
751:
752:
753: /************************************************************
754: Function gets the proposed employee salary from
755: per_pay_proposals. If the Salary Proposal is not specified
756: then it checks the Salary Basis for the employee, find out
757: the element associated with the Salary Basis and get the
758: value from the run results for the given period.
759: If the element associated with the Salary Basis is Regular
771: cursor c_salary_proposal (cp_assignment_id in number,
772: cp_period_start_date in date,
773: cp_period_end_date in date) is
774: select ppp.proposed_salary_n
775: from per_pay_proposals ppp
776: where ppp.assignment_id = cp_assignment_id
777: and ppp.change_date =
778: (select max(change_date)
779: from per_pay_proposals ppp1
775: from per_pay_proposals ppp
776: where ppp.assignment_id = cp_assignment_id
777: and ppp.change_date =
778: (select max(change_date)
779: from per_pay_proposals ppp1
780: where ppp1.assignment_id = cp_assignment_id
781: and ppp1.approved = 'Y'
782: and ppp1.change_date <= cp_period_end_date);
783: