APPS.PAY_US_TAX_BALANCE_PERF dependencies on PAY_PAYROLL_ACTIONS

Line 158: FROM pay_assignment_actions paa,pay_payroll_actions ppa

154: RETURN number IS
155:
156: CURSOR get_year (p_assign_action_id NUMBER) IS
157: SELECT TO_CHAR(effective_date,'YYYY')
158: FROM pay_assignment_actions paa,pay_payroll_actions ppa
159: WHERE ppa.payroll_action_id = paa.payroll_action_id
160: AND paa.assignment_action_id = p_assign_action_id;
161:
162: --