APPS.PAY_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1135: aactid pay_assignment_actions.assignment_action_id%TYPE;

1131: -- within a loop
1132: --==================================================================
1133: PROCEDURE process_employee(p_assact_id in number) IS
1134: result ff_archive_items.value%TYPE;
1135: aactid pay_assignment_actions.assignment_action_id%TYPE;
1136: i INTEGER;
1137: pactid NUMBER;
1138: l_flag BOOLEAN;
1139: BEGIN

Line 1279: type t_aa_list is table of pay_assignment_actions.assignment_action_id%type;

1275: procedure remove_report_actions(p_pact_id in number,
1276: p_chunk_no in number default null)
1277: is
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;

Line 1290: from pay_assignment_actions

1286: --
1287: cursor asgcur (p_payroll_act in number)
1288: is
1289: select assignment_action_id
1290: from pay_assignment_actions
1291: where payroll_action_id = p_payroll_act;
1292: --
1293: cursor objcur (p_payroll_act in number)
1294: is

Line 1302: from pay_assignment_actions

1298: --
1299: cursor asgrescur (p_payroll_act in number, p_chunk in number)
1300: is
1301: select assignment_action_id
1302: from pay_assignment_actions
1303: where payroll_action_id = p_payroll_act
1304: and chunk_number = p_chunk;
1305: --
1306: begin

Line 1324: delete from pay_assignment_actions

1320: where source_id = aalist(i)
1321: and source_type = 'A';
1322: --
1323: forall i in 1..aalist.count
1324: delete from pay_assignment_actions
1325: where assignment_action_id = aalist(i);
1326: --
1327: exit when asgcur%notfound;
1328: end loop;

Line 1376: delete from pay_assignment_actions

1372: exit when asgrescur%notfound;
1373: end loop;
1374: close asgrescur;
1375: --
1376: delete from pay_assignment_actions
1377: where payroll_action_id = p_pact_id
1378: and chunk_number = p_chunk_no;
1379: --
1380: end if;