APPS.PAY_VOID_PAYMENTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 32: FROM pay_assignment_actions chq_or_mag_aa,

28: CURSOR overlap_csr IS
29: SELECT void_pa.effective_date,
30: fnd_number.canonical_to_number(chq_or_mag_aa.serial_number) cheque_number,
31: chq_or_mag_aa.assignment_action_id
32: FROM pay_assignment_actions chq_or_mag_aa,
33: pay_action_interlocks,
34: pay_assignment_actions void_aa,
35: pay_payroll_actions void_pa
36: WHERE chq_or_mag_aa.payroll_action_id = p_payroll_action_id

Line 34: pay_assignment_actions void_aa,

30: fnd_number.canonical_to_number(chq_or_mag_aa.serial_number) cheque_number,
31: chq_or_mag_aa.assignment_action_id
32: FROM pay_assignment_actions chq_or_mag_aa,
33: pay_action_interlocks,
34: pay_assignment_actions void_aa,
35: pay_payroll_actions void_pa
36: WHERE chq_or_mag_aa.payroll_action_id = p_payroll_action_id
37: AND ((l_start_cheque is not null
38: AND l_end_cheque is not null

Line 64: FROM pay_assignment_actions act,

60: -- from pay_ce_reconciled_payments prp
61: -- where prp.assignment_action_id = act.assignment_action_id)
62: -- ,'N') recon_exists,
63: nvl(pos.final_process_date, hr_general.end_of_time) final_process_date
64: FROM pay_assignment_actions act,
65: per_assignments_f asg,
66: per_periods_of_service pos
67: WHERE act.payroll_action_id = p_payroll_action_id
68: AND ((l_start_assignment is null and l_end_assignment is null)

Line 234: INSERT INTO pay_assignment_actions

230: hr_utility.set_location ('void_run',63);
231: --------------------------------------------------------------------------------
232: -- Create new assignment action for void
233: --------------------------------------------------------------------------------
234: INSERT INTO pay_assignment_actions
235: ( assignment_action_id,
236: assignment_id,
237: payroll_action_id,
238: action_status,

Line 243: ( pay_assignment_actions_s.nextval, -- assignment_action_id

239: serial_number,
240: object_version_number,
241: action_sequence,
242: tax_unit_id ) VALUES
243: ( pay_assignment_actions_s.nextval, -- assignment_action_id
244: void_row.assignment_id, -- assignment_id
245: pay_payroll_actions_s.currval, -- payroll_action_id
246: 'C', -- action_status
247: void_row.cheque_number, -- serial_number

Line 249: pay_assignment_actions_s.nextval,

245: pay_payroll_actions_s.currval, -- payroll_action_id
246: 'C', -- action_status
247: void_row.cheque_number, -- serial_number
248: void_row.object_version_number, -- object_version_number
249: pay_assignment_actions_s.nextval,
250: void_row.tax_unit_id ); -- action_sequence
251:
252: -- bug 9960968
253: l_no_of_chq_processed := l_no_of_chq_processed + 1;

Line 262: ( pay_assignment_actions_s.currval,void_row.assignment_action_id );

258: --------------------------------------------------------------------------------
259: INSERT INTO pay_action_interlocks
260: ( locking_action_id, locked_action_id )
261: VALUES
262: ( pay_assignment_actions_s.currval,void_row.assignment_action_id );
263: --
264: hr_utility.set_location ('void_run',64);
265: END LOOP;
266: --