DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_ALL_ASSIGNMENTS_F

Line 269: per_all_assignments_f paf

265: paf.assignment_id,
266: pai.action_information2
267: FROM
268: pay_action_information pai,
269: per_all_assignments_f paf
270: WHERE paf.person_id = to_number(v_person_id)
271: AND paf.assignment_id = pai.assignment_id
272: AND pai.action_information_category = 'EMPLOYEE PAYMENT INFORMATION'
273: AND pai.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date