DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on PER_PAY_PROPOSALS

Line 2947: from per_pay_proposals ppp,

2943: ,c_eff_date in date
2944: )
2945: is
2946: select ppp.PAY_PROPOSAL_ID
2947: from per_pay_proposals ppp,
2948: per_assignments_f asg
2949: where ppp.assignment_id = asg.assignment_id
2950: and c_eff_date
2951: between asg.effective_start_date and asg.effective_end_date

Line 2967: from per_pay_proposals ppp,

2963: ppb.pay_annualization_factor,
2964: paf.period_type payroll,
2965: asg.normal_hours,
2966: asg.frequency
2967: from per_pay_proposals ppp,
2968: per_assignments_f asg,
2969: per_pay_bases ppb,
2970: pay_all_payrolls_f paf,
2971: per_all_people_f per

Line 4778: from per_pay_proposals ppp

4774: (c_asg_id in number
4775: )
4776: is
4777: select ppp.change_date
4778: from per_pay_proposals ppp
4779: where ppp.assignment_id = c_asg_id
4780: order by ppp.change_date desc;
4781: --
4782: l_asgppp c_asgppp%rowtype;