DBA Data[Home] [Help]

APPS.PAY_VOID_PAYMENTS dependencies on PAY_ACTION_INTERLOCKS

Line 33: pay_action_interlocks,

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
37: AND ((l_start_cheque is not null

Line 259: INSERT INTO pay_action_interlocks

255: hr_utility.set_location ('void_run',63);
256: --------------------------------------------------------------------------------
257: -- Create interlock from void aa to cheque aa
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: --