DBA Data[Home] [Help]

APPS.BEN_WHATIF_ELIG dependencies on PER_PAY_PROPOSALS

Line 4036: select * from per_pay_proposals pyp

4032: ,p_effective_date in date
4033: ) is
4034:
4035: cursor c_pay_rec is
4036: select * from per_pay_proposals pyp
4037: where pyp.assignment_id in
4038: (select assignment_id
4039: from per_all_assignments_f
4040: where person_id = p_person_id

Line 4052: per_pay_rec per_pay_proposals%rowtype;

4048: and business_group_id = p_business_group_id;
4049:
4050: l_assignment_id number;
4051: l_object_version_number number;
4052: per_pay_rec per_pay_proposals%rowtype;
4053: l_pay_rec c_pay_rec%rowtype;
4054:
4055: l_pay_proposal_id number;
4056: l_element_entry_id number;