APPS.PAY_VOID_PAYMENTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 31: FROM pay_assignment_actions chq_or_mag_aa,

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

Line 33: pay_assignment_actions void_aa,

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

Line 63: FROM pay_assignment_actions act,

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

Line 227: INSERT INTO pay_assignment_actions

223: hr_utility.set_location ('void_run',63);
224: --------------------------------------------------------------------------------
225: -- Create new assignment action for void
226: --------------------------------------------------------------------------------
227: INSERT INTO pay_assignment_actions
228: ( assignment_action_id,
229: assignment_id,
230: payroll_action_id,
231: action_status,

Line 236: ( pay_assignment_actions_s.nextval, -- assignment_action_id

232: serial_number,
233: object_version_number,
234: action_sequence,
235: tax_unit_id ) VALUES
236: ( pay_assignment_actions_s.nextval, -- assignment_action_id
237: void_row.assignment_id, -- assignment_id
238: pay_payroll_actions_s.currval, -- payroll_action_id
239: 'C', -- action_status
240: void_row.cheque_number, -- serial_number

Line 242: pay_assignment_actions_s.nextval,

238: pay_payroll_actions_s.currval, -- payroll_action_id
239: 'C', -- action_status
240: void_row.cheque_number, -- serial_number
241: void_row.object_version_number, -- object_version_number
242: pay_assignment_actions_s.nextval,
243: void_row.tax_unit_id ); -- action_sequence
244: --
245: hr_utility.set_location ('void_run',63);
246: --------------------------------------------------------------------------------

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

248: --------------------------------------------------------------------------------
249: INSERT INTO pay_action_interlocks
250: ( locking_action_id, locked_action_id )
251: VALUES
252: ( pay_assignment_actions_s.currval,void_row.assignment_action_id );
253: --
254: hr_utility.set_location ('void_run',64);
255: END LOOP;
256: --