DBA Data[Home] [Help]

APPS.PAY_GB_EDI_P46_CAR dependencies on PER_ASSIGNMENTS_F

Line 257: per_assignments_f asg,

253: CURSOR c_tax_ref(p_assignment_id IN NUMBER,
254: p_eff_date IN DATE) IS
255: SELECT flex.segment1 tax_ref
256: FROM hr_soft_coding_keyflex flex,
257: per_assignments_f asg,
258: Pay_payrolls_f ppf
259: WHERE asg.assignment_id = p_assignment_id
260: AND p_eff_date BETWEEN asg.effective_start_date AND asg.effective_end_date
261: AND asg.payroll_id = ppf.payroll_id

Line 2918: FROM per_people_f p, per_assignments_f a

2914: , p.person_id
2915: , p.national_identifier
2916: , p.date_of_birth --For Bug 6652235
2917: , p.sex --For Bug 6652235
2918: FROM per_people_f p, per_assignments_f a
2919: WHERE a.assignment_id = p_assignment_id
2920: AND l_eff_date between
2921: a.effective_start_date and a.effective_end_date
2922: AND a.person_id = p.person_id