APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1344: FROM pay_payroll_actions

1340: WHERE hasa.assignment_set_id = p_assignment_set_id;
1341: --
1342: CURSOR get_year(c_payroll_action_id NUMBER) IS
1343: SELECT TO_CHAR(effective_date,'RRRR')
1344: FROM pay_payroll_actions
1345: WHERE payroll_action_id = c_payroll_action_id;
1346: --
1347: --11900414 Starts
1348: CURSOR c_usr_tab_col IS

Line 1378: FROM pay_payroll_actions

1374:
1375: CURSOR c_bg_stdate(p_payroll_action_id IN NUMBER) IS
1376: SELECT business_group_id
1377: ,start_date
1378: FROM pay_payroll_actions
1379: WHERE payroll_action_id = p_payroll_action_id;
1380:
1381: l_user_table_id NUMBER;
1382: l_user_column_id NUMBER;