DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_PAY_PROPOSALS

Line 8603: per_pay_proposals ppp

8599: ,p_lf_evt_ocrd_dt date
8600: ,p_pay_basis_id number) is
8601: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
8602: from per_pay_bases ppb,
8603: per_pay_proposals ppp
8604: where ppb.pay_basis_id = p_pay_basis_id
8605: and ppb.business_group_id = p_business_group_id
8606: and ppp.assignment_id = p_assignment_id
8607: and ppp.change_date <= p_lf_evt_ocrd_dt

Line 8615: from per_pay_proposals ppp

8611: ,p_business_group_id number
8612: ,p_lf_evt_ocrd_dt date
8613: ) is
8614: select ppp.proposed_salary_n
8615: from per_pay_proposals ppp
8616: where ppp.assignment_id = p_assignment_id
8617: and ppp.business_group_id = p_business_group_id
8618: and ppp.approved = 'Y'
8619: and ppp.change_date <= p_lf_evt_ocrd_dt