DBA Data[Home] [Help]

APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_TEMP_OBJECT_ACTIONS

Line 1421: FROM pay_temp_object_actions paa

1417: CURSOR c_xfr_info (p_assignment_action_id NUMBER) IS
1418: SELECT paa.payroll_action_id,
1419: paa.object_id,
1420: paa.object_type
1421: FROM pay_temp_object_actions paa
1422: WHERE paa.object_action_id = p_assignment_action_id;
1423:
1424: CURSOR c_mode ( p_payroll_action_id NUMBER) IS
1425: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)

Line 1953: FROM pay_temp_object_actions

1949: AND process_mode = l_mode
1950: AND process_date = l_date
1951: AND assignment_id IN
1952: (SELECT object_id
1953: FROM pay_temp_object_actions
1954: WHERE payroll_action_id = p_payroll_action_id
1955: AND action_status = 'E');
1956:
1957: pay_us_psd_upgrade_pkg.generate_output(l_mode);