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 579: ** per_pay_proposals. If the Salary Proposal is not specified

575:
576:
577: /************************************************************
578: ** Function gets the proposed employee salary from
579: ** per_pay_proposals. If the Salary Proposal is not specified
580: ** then it checks the Salary Basis for the employee, find out
581: ** the element associated with the Salary Basis and get the
582: ** value from the run results for the given period.
583: ** If the element associated with the Salary Basis is Regular

Line 597: from per_pay_proposals ppp

593:
594: cursor c_salary_proposal (cp_assignment_id in number,
595: cp_date_earned in date) is
596: select ppp.proposed_salary_n
597: from per_pay_proposals ppp
598: where ppp.assignment_id = cp_assignment_id
599: and ppp.change_date =
600: (select max(change_date)
601: from per_pay_proposals ppp1

Line 601: from per_pay_proposals ppp1

597: from per_pay_proposals ppp
598: where ppp.assignment_id = cp_assignment_id
599: and ppp.change_date =
600: (select max(change_date)
601: from per_pay_proposals ppp1
602: where ppp1.assignment_id = cp_assignment_id
603: and ppp1.approved = 'Y'
604: /* Following modified for Bug# 7604041 */
605: /* and ppp1.change_date <= cp_date_earned */