DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_PAY_PROPOSALS

Line 6596: per_pay_proposals ppp

6592: ,p_lf_evt_ocrd_dt date
6593: ,p_pay_basis_id number) is
6594: select ppp.proposed_salary_n * ppb.pay_annualization_factor annual_salary
6595: from per_pay_bases ppb,
6596: per_pay_proposals ppp
6597: where ppb.pay_basis_id = p_pay_basis_id
6598: and ppb.business_group_id = p_business_group_id
6599: and ppp.assignment_id = p_assignment_id
6600: and ppp.change_date <= p_lf_evt_ocrd_dt

Line 6609: from per_pay_proposals ppp

6605: ,p_business_group_id number
6606: ,p_lf_evt_ocrd_dt date
6607: ) is
6608: select ppp.proposed_salary_n
6609: from per_pay_proposals ppp
6610: where ppp.assignment_id = p_assignment_id
6611: and ppp.business_group_id = p_business_group_id
6612: and ppp.approved = 'Y'
6613: and ppp.change_date <= p_lf_evt_ocrd_dt