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_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_PAY_PROPOSALS

Line 1343: per_pay_proposals. If the Salary Proposal is not specified

1339:
1340:
1341: /************************************************************
1342: Function gets the proposed employee salary from
1343: per_pay_proposals. If the Salary Proposal is not specified
1344: then it checks the Salary Basis for the employee, find out
1345: the element associated with the Salary Basis and get the
1346: value from the run results for the given period.
1347: If the element associated with the Salary Basis is Regular

Line 1363: from per_pay_proposals ppp

1359: cursor c_salary_proposal (cp_assignment_id in number,
1360: cp_period_start_date in date,
1361: cp_period_end_date in date) is
1362: select ppp.proposed_salary_n
1363: from per_pay_proposals ppp
1364: where ppp.assignment_id = cp_assignment_id
1365: and ppp.change_date =
1366: (select max(change_date)
1367: from per_pay_proposals ppp1

Line 1367: from per_pay_proposals ppp1

1363: from per_pay_proposals ppp
1364: where ppp.assignment_id = cp_assignment_id
1365: and ppp.change_date =
1366: (select max(change_date)
1367: from per_pay_proposals ppp1
1368: where ppp1.assignment_id = cp_assignment_id
1369: and ppp1.approved = 'Y'
1370: and ppp1.change_date <= cp_period_end_date);
1371: