APPS.HR_US_W2_REP dependencies on PAY_PAYROLL_ACTIONS

Line 270: FROM pay_assignment_actions paa,pay_payroll_actions ppa

266: w2_jurisdiction_level number) RETURN NUMBER IS
267:
268: CURSOR get_reporting_year (p_assign_action_id NUMBER) IS
269: SELECT TO_CHAR(effective_date,'YYYY')
270: FROM pay_assignment_actions paa,pay_payroll_actions ppa
271: WHERE ppa.payroll_action_id = paa.payroll_action_id
272: AND paa.assignment_action_id = p_assign_action_id;
273:
274: CURSOR check_archive_data (p_assign_action_id NUMBER) IS