eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_PAY_PROPOSALS

Line 543: ** per_pay_proposals. If the Salary Proposal is not specified

539:
540:
541: /************************************************************
542: ** Function gets the proposed employee salary from
543: ** per_pay_proposals. If the Salary Proposal is not specified
544: ** then it checks the Salary Basis for the employee, find out
545: ** the element associated with the Salary Basis and get the
546: ** value from the run results for the given period.
547: ** If the element associated with the Salary Basis is Regular

Line 561: from per_pay_proposals ppp

557:
558: cursor c_salary_proposal (cp_assignment_id in number,
559: cp_date_earned in date) is
560: select ppp.proposed_salary_n
561: from per_pay_proposals ppp
562: where ppp.assignment_id = cp_assignment_id
563: and ppp.change_date =
564: (select max(change_date)
565: from per_pay_proposals ppp1

Line 565: from per_pay_proposals ppp1

561: from per_pay_proposals ppp
562: where ppp.assignment_id = cp_assignment_id
563: and ppp.change_date =
564: (select max(change_date)
565: from per_pay_proposals ppp1
566: where ppp1.assignment_id = cp_assignment_id
567: and ppp1.approved = 'Y'
568: and ppp1.change_date <= cp_date_earned);
569: