DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_PAY_PROPOSALS

Line 6539: per_pay_proposals ppp

6535: ,p_lf_evt_ocrd_dt date
6536: ,p_pay_basis_id number) is
6537: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
6538: from per_pay_bases ppb,
6539: per_pay_proposals ppp
6540: where ppb.pay_basis_id = p_pay_basis_id
6541: and ppb.business_group_id = p_business_group_id
6542: and ppp.assignment_id = p_assignment_id
6543: and ppp.change_date <= p_lf_evt_ocrd_dt

Line 6552: from per_pay_proposals ppp

6548: ,p_business_group_id number
6549: ,p_lf_evt_ocrd_dt date
6550: ) is
6551: select ppp.proposed_salary_n
6552: from per_pay_proposals ppp
6553: where ppp.assignment_id = p_assignment_id
6554: and ppp.business_group_id = p_business_group_id
6555: and ppp.approved = 'Y'
6556: and ppp.change_date <= p_lf_evt_ocrd_dt