APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on PER_PAY_PROPOSALS

Line 549: , per_pay_proposals ppp

545: , ppp.proposed_salary_n
546: , ppp.object_version_number
547: FROM per_all_assignments_f asg
548: , per_pay_bases ppb
549: , per_pay_proposals ppp
550: , ben_cwb_person_info per
551: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
552: AND asg.assignment_id = per.assignment_id
553: AND v_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 559: FROM per_pay_proposals ppp1

555: AND ppp.assignment_id = asg.assignment_id
556: AND ppp.approved = 'Y'
557: AND ppp.change_date =
558: (SELECT MAX (ppp1.change_date)
559: FROM per_pay_proposals ppp1
560: WHERE ppp1.assignment_id = asg.assignment_id
561: AND ppp1.approved = 'Y'
562: AND change_date <= v_effective_date);
563:

Line 567: FROM per_pay_proposals ppp

563:
564: CURSOR c_future_pay_proposal (v_group_per_in_ler_id IN NUMBER, v_effective_date IN DATE)
565: IS
566: SELECT ppp.proposed_salary_n
567: FROM per_pay_proposals ppp
568: , ben_cwb_person_info per
569: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
570: AND ppp.assignment_id = per.assignment_id
571: AND ppp.change_date > v_effective_date

Line 658: from per_pay_proposals

654:
655: CURSOR c_posted_salary(v_pay_proposal_id IN NUMBER)
656: IS
657: select proposed_salary_n
658: from per_pay_proposals
659: where pay_proposal_id = v_pay_proposal_id;
660:
661: CURSOR c_posted_rating(v_person_id IN NUMBER,
662: v_effective_date IN DATE)

Line 2425: from per_pay_proposals

2421: l_pay_proposal_id_prev number := -1;
2422: --
2423: cursor c_pay_proposals is
2424: select object_version_number, business_group_id
2425: from per_pay_proposals
2426: where pay_proposal_id = l_pay_proposal_id;
2427:
2428: cursor c_proposed_salary is
2429: select proposed_salary_n

Line 2430: from per_pay_proposals

2426: where pay_proposal_id = l_pay_proposal_id;
2427:
2428: cursor c_proposed_salary is
2429: select proposed_salary_n
2430: from per_pay_proposals
2431: where pay_proposal_id = l_pay_proposal_id;
2432:
2433: cursor c_element_entry_val(l_element_entry_val_id IN number) is
2434: select screen_entry_value from pay_element_entry_values_f