DBA Data[Home] [Help]

APPS.BEN_ASSIGNMENT_INTERNAL dependencies on PER_PAY_PROPOSALS

Line 701: from per_pay_proposals

697: (c_pyp_id in number
698: )
699: Is
700: select *
701: from per_pay_proposals
702: where pay_proposal_id = c_pyp_id;
703: --
704: cursor c_getbgpdefpet
705: (c_bgp_id in number

Line 2322: per_pay_proposals pyp

2318: )
2319: Is
2320: select pyp.proposed_salary_n
2321: from per_all_assignments_f asg,
2322: per_pay_proposals pyp
2323: where asg.assignment_id = pyp.assignment_id
2324: and c_eff_date
2325: between asg.effective_start_date and asg.effective_end_date
2326: and asg.person_id = c_person_id