DBA Data[Home] [Help]

APPS.PAY_VOID_PAYMENTS dependencies on PAY_ACTION_INTERLOCKS

Line 32: pay_action_interlocks,

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

Line 249: INSERT INTO pay_action_interlocks

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