APPS.PAY_RETRO_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 707: l_serial_number pay_assignment_actions.serial_number%type;

703: and paa2.payroll_action_id = paa.payroll_action_id
704: and paa.assignment_id is not null;
705: --
706: l_adj_start_date date;
707: l_serial_number pay_assignment_actions.serial_number%type;
708: --
709: begin
710: --
711: p_adj_start_date := p_start_date;

Line 1190: select pay_assignment_actions_s.nextval,

1186: source_action_id,
1187: object_id,
1188: object_type
1189: )
1190: select pay_assignment_actions_s.nextval,
1191: asgrec.source_id,
1192: p_pactid,
1193: 'U',
1194: p_chunk_number,

Line 1195: pay_assignment_actions_s.nextval,

1191: asgrec.source_id,
1192: p_pactid,
1193: 'U',
1194: p_chunk_number,
1195: pay_assignment_actions_s.nextval,
1196: 1,
1197: asgrec.tax_unit_id,
1198: actrec.assignment_action_id,
1199: actrec.process_group_id,

Line 1212: set action_sequence = pay_assignment_actions_s.nextval

1208: end loop;
1209: --
1210: -- Now update the master Sequence
1211: update pay_assignment_actions
1212: set action_sequence = pay_assignment_actions_s.nextval
1213: where assignment_action_id = actrec.assignment_action_id;
1214: --
1215: end loop;
1216: --