APPS.PAY_ARCHIVE dependencies on PAY_TEMP_OBJECT_ACTIONS

Line 49: nbristow 16-DEC-2003 Now delteting from pay_temp_object_actions.

45: csr_defined_balance cursor.
46: nbristow 16-JUL-2002 Added standard_deinit.
47: alogue 23-JUN-2003 Handle removal of lines from pay_population_ranges
48: in remove_report_actions. Bug 3017447.
49: nbristow 16-DEC-2003 Now delteting from pay_temp_object_actions.
50: alogue 25-FEB-2004 Bulk operations within remove_report_actions
51: for performance purposes.
52: nbristow 09-JUL-2004 Added process_chunk.
53: mreid 11-NOV-2005 Bug 4729140: added date effective joins in

Line 1282: type t_obj_list is table of pay_temp_object_actions.object_action_id%type;

1278: --
1279: type t_aa_list is table of pay_assignment_actions.assignment_action_id%type;
1280: aalist t_aa_list;
1281:
1282: type t_obj_list is table of pay_temp_object_actions.object_action_id%type;
1283: objlist t_obj_list;
1284:
1285: i number;
1286: --

Line 1296: from pay_temp_object_actions

1292: --
1293: cursor objcur (p_payroll_act in number)
1294: is
1295: select object_action_id
1296: from pay_temp_object_actions
1297: where payroll_action_id = p_payroll_act;
1298: --
1299: cursor asgrescur (p_payroll_act in number, p_chunk in number)
1300: is

Line 1341: delete from pay_temp_object_actions

1337: where source_id = objlist(i)
1338: and source_type = 'A';
1339: --
1340: forall i in 1..objlist.count
1341: delete from pay_temp_object_actions
1342: where object_action_id = objlist(i);
1343: --
1344: exit when objcur%notfound;
1345: end loop;