APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PER_PAY_PROPOSALS

Line 24: ,per_pay_proposals ppp

20: ,nvl(ppb.pay_annualization_factor,1) salary_ann_fctr
21: ,get_fte_factor(v_assignment_id
22: ,v_effective_date) fte_factor
23: from per_all_assignments_f paf
24: ,per_pay_proposals ppp
25: ,per_pay_bases ppb
26: where ppp.assignment_id = v_assignment_id
27: and ppp.approved = 'Y'
28: and ppp.change_date =

Line 30: from per_pay_proposals ppp1

26: where ppp.assignment_id = v_assignment_id
27: and ppp.approved = 'Y'
28: and ppp.change_date =
29: (select max(ppp1.change_date)
30: from per_pay_proposals ppp1
31: where ppp1.assignment_id = v_assignment_id
32: and ppp1.change_date <= v_effective_date
33: and ppp1.approved = 'Y')
34: and paf.assignment_id = ppp.assignment_id

Line 641: ,per_pay_proposals ppp

637: ,per_all_assignments_f supv_asg
638: ,hr_organization_information bg
639: ,hr_organization_information supv_bg
640: ,per_periods_of_service service_period
641: ,per_pay_proposals ppp
642: ,pay_all_payrolls_f pay
643: ,(select rtg1.review_date review_date
644: ,rtg1.performance_rating performance_rating
645: ,rtg1.person_id person_id

Line 657: ,per_pay_proposals ppp_prev

653: and evt1.event_id = apr.event_id(+)) perf
654: ,per_pay_bases ppb
655: ,pay_people_groups grp
656: ,per_all_assignments_f paf_prev
657: ,per_pay_proposals ppp_prev
658: ,per_pay_bases ppb_prev
659: where pil.per_in_ler_id = p_group_per_in_ler_id
660: and paf.assignment_id = pil.assignment_id
661: and p_effective_date between paf.effective_start_date and

Line 684: from per_pay_proposals ppp1

680: and ppp.change_date (+) <= p_effective_date
681: and nvl(ppp.change_date,to_date('4712/12/31', 'yyyy/mm/dd')) =
682: (select nvl(max(ppp1.change_date), to_date('4712/12/31',
683: 'yyyy/mm/dd'))
684: from per_pay_proposals ppp1
685: where ppp1.assignment_id = ppp.assignment_id
686: and ppp1.change_date <= p_effective_date
687: and ppp1.approved = 'Y')
688: and paf.payroll_id = pay.payroll_id (+)

Line 709: from per_pay_proposals ppp1

705: and ppp_prev.change_date (+) < ppp.change_date
706: and nvl(ppp_prev.change_date, to_date('4712/12/31', 'yyyy/mm/dd')) =
707: (select nvl(max(ppp1.change_date), to_date('4712/12/31',
708: 'yyyy/mm/dd'))
709: from per_pay_proposals ppp1
710: where ppp1.assignment_id = ppp.assignment_id
711: and ppp1.change_date < ppp.change_date
712: and ppp1.approved = 'Y')
713: and paf_prev.assignment_id (+) = ppp_prev.assignment_id