DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on PER_ASSIGNMENTS_F

Line 2948: per_assignments_f asg

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
2952: and asg.person_id = c_per_id;

Line 2968: per_assignments_f asg,

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
2972: where per.person_id = c_person_id