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 867: , per_pay_proposals ppp

863: , ppp.proposed_salary_n
864: , ppp.object_version_number
865: FROM per_all_assignments_f asg
866: , per_pay_bases ppb
867: , per_pay_proposals ppp
868: , ben_cwb_person_info per
869: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
870: AND asg.assignment_id = per.assignment_id
871: AND v_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 877: FROM per_pay_proposals ppp1

873: AND ppp.assignment_id = asg.assignment_id
874: AND ppp.approved = 'Y'
875: AND ppp.change_date =
876: (SELECT MAX (ppp1.change_date)
877: FROM per_pay_proposals ppp1
878: WHERE ppp1.assignment_id = asg.assignment_id
879: AND ppp1.approved = 'Y'
880: AND change_date < v_effective_date);
881:

Line 885: FROM per_pay_proposals ppp

881:
882: CURSOR c_future_pay_proposal (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
883: IS
884: SELECT ppp.proposed_salary_n
885: FROM per_pay_proposals ppp
886: , ben_cwb_person_info per
887: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
888: AND ppp.assignment_id = per.assignment_id
889: AND ppp.change_date > v_effective_date;

Line 1094: from per_pay_proposals

1090:
1091: CURSOR c_posted_salary(v_pay_proposal_id IN NUMBER)
1092: IS
1093: select proposed_salary_n
1094: from per_pay_proposals
1095: where pay_proposal_id = v_pay_proposal_id;
1096:
1097: CURSOR c_posted_rating(v_person_id IN NUMBER,
1098: v_effective_date IN DATE)