DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_INTERNAL dependencies on PER_PAY_PROPOSALS

Line 495: from per_pay_proposals

491: (c_pyp_id in number
492: )
493: Is
494: select *
495: from per_pay_proposals
496: where pay_proposal_id = c_pyp_id;
497: --
498: cursor c_getbgpdefpet
499: (c_bgp_id in number

Line 2210: per_pay_proposals pyp

2206: )
2207: Is
2208: select pyp.proposed_salary_n
2209: from per_all_assignments_f asg,
2210: per_pay_proposals pyp
2211: where asg.assignment_id = pyp.assignment_id
2212: and c_eff_date
2213: between asg.effective_start_date and asg.effective_end_date
2214: and asg.person_id = c_person_id