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

Line 879: , per_pay_proposals ppp

875: , ppp.proposed_salary_n
876: , ppp.object_version_number
877: FROM per_all_assignments_f asg
878: , per_pay_bases ppb
879: , per_pay_proposals ppp
880: , ben_cwb_person_info per
881: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
882: AND asg.assignment_id = per.assignment_id
883: AND v_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 889: FROM per_pay_proposals ppp1

885: AND ppp.assignment_id = asg.assignment_id
886: AND ppp.approved = 'Y'
887: AND ppp.change_date =
888: (SELECT MAX (ppp1.change_date)
889: FROM per_pay_proposals ppp1
890: WHERE ppp1.assignment_id = asg.assignment_id
891: AND ppp1.approved = 'Y'
892: AND change_date < v_effective_date);
893:

Line 897: FROM per_pay_proposals ppp

893:
894: CURSOR c_future_pay_proposal (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
895: IS
896: SELECT ppp.proposed_salary_n
897: FROM per_pay_proposals ppp
898: , ben_cwb_person_info per
899: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
900: AND ppp.assignment_id = per.assignment_id
901: AND ppp.change_date > v_effective_date;

Line 1107: from per_pay_proposals

1103:
1104: CURSOR c_posted_salary(v_pay_proposal_id IN NUMBER)
1105: IS
1106: select proposed_salary_n
1107: from per_pay_proposals
1108: where pay_proposal_id = v_pay_proposal_id;
1109:
1110: CURSOR c_posted_rating(v_person_id IN NUMBER,
1111: v_effective_date IN DATE)