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.HR_AUTH_BRIDGE dependencies on PER_PAY_PROPOSALS

Line 306: FROM per_pay_proposals ppp

302: --
303:
304: CURSOR c_salary IS
305: SELECT TO_CHAR(ppp.proposed_salary_n)
306: FROM per_pay_proposals ppp
307: WHERE ppp.pay_proposal_id = (SELECT MAX(ppp1.pay_proposal_id)
308: FROM per_pay_proposals ppp1
309: WHERE ppp1.assignment_id = p_assignment_id
310: AND ppp1.approved = 'Y'

Line 308: FROM per_pay_proposals ppp1

304: CURSOR c_salary IS
305: SELECT TO_CHAR(ppp.proposed_salary_n)
306: FROM per_pay_proposals ppp
307: WHERE ppp.pay_proposal_id = (SELECT MAX(ppp1.pay_proposal_id)
308: FROM per_pay_proposals ppp1
309: WHERE ppp1.assignment_id = p_assignment_id
310: AND ppp1.approved = 'Y'
311: AND ppp1.change_date <= p_effective_date);
312:

Line 355: FROM per_pay_proposals ppp

351: --
352:
353: CURSOR c_change_dt IS
354: SELECT TO_CHAR(ppp.change_date,'MM/DD/YYYY')
355: FROM per_pay_proposals ppp
356: WHERE ppp.pay_proposal_id = (SELECT MAX(ppp1.pay_proposal_id)
357: FROM per_pay_proposals ppp1
358: WHERE ppp1.assignment_id = p_assignment_id
359: AND ppp1.approved = 'Y'

Line 357: FROM per_pay_proposals ppp1

353: CURSOR c_change_dt IS
354: SELECT TO_CHAR(ppp.change_date,'MM/DD/YYYY')
355: FROM per_pay_proposals ppp
356: WHERE ppp.pay_proposal_id = (SELECT MAX(ppp1.pay_proposal_id)
357: FROM per_pay_proposals ppp1
358: WHERE ppp1.assignment_id = p_assignment_id
359: AND ppp1.approved = 'Y'
360: AND ppp1.change_date <= p_effective_date);
361: