DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_PAY_PROPOSALS

Line 8621: per_pay_proposals ppp

8617: ,p_lf_evt_ocrd_dt date
8618: ,p_pay_basis_id number) is
8619: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
8620: from per_pay_bases ppb,
8621: per_pay_proposals ppp
8622: where ppb.pay_basis_id = p_pay_basis_id
8623: and ppb.business_group_id = p_business_group_id
8624: and ppp.assignment_id = p_assignment_id
8625: and ppp.change_date <= p_lf_evt_ocrd_dt

Line 8633: from per_pay_proposals ppp

8629: ,p_business_group_id number
8630: ,p_lf_evt_ocrd_dt date
8631: ) is
8632: select ppp.proposed_salary_n
8633: from per_pay_proposals ppp
8634: where ppp.assignment_id = p_assignment_id
8635: and ppp.business_group_id = p_business_group_id
8636: and ppp.approved = 'Y'
8637: and ppp.change_date <= p_lf_evt_ocrd_dt