DBA Data[Home] [Help]

APPS.PAY_US_W2C_IN_MMREF2_FORMAT dependencies on PAY_PAYROLL_ACTIONS

Line 1406: FROM pay_assignment_actions paa,pay_payroll_actions ppa

1402: IS
1403:
1404: CURSOR get_reporting_year (p_assign_action_id NUMBER) IS
1405: SELECT TO_CHAR(effective_date,'YYYY')
1406: FROM pay_assignment_actions paa,pay_payroll_actions ppa
1407: WHERE ppa.payroll_action_id = paa.payroll_action_id
1408: AND paa.assignment_action_id = p_assign_action_id;
1409:
1410: i number := 0;