DBA Data[Home] [Help]

APPS.PAY_IP_UTILITY dependencies on PAY_ACTION_INTERLOCKS

Line 605: pay_action_interlocks pai

601: paa_pymt.serial_number),ppa_pymt.action_type
602: FROM pay_pre_payments ppp,
603: pay_assignment_actions paa_pymt,
604: pay_payroll_actions ppa_pymt,
605: pay_action_interlocks pai
606: WHERE pai.locked_action_id = cp_pre_payment_action
607: AND paa_pymt.assignment_action_id = pai.locking_action_id
608: AND ppa_pymt.payroll_action_id = paa_pymt.payroll_action_id
609: AND ppa_pymt.action_type in ('M','H', 'E')

Line 616: pay_action_interlocks pai_void

612: AND NOT EXISTS (
613: SELECT 1
614: FROM pay_payroll_actions ppa,
615: pay_assignment_actions paa,
616: pay_action_interlocks pai_void
617: WHERE pai_void.locked_action_id = paa_pymt.assignment_action_id --Void
618: /* Check if the locking is that of Void Pymt */
619: AND pai_void.locking_action_id = paa.assignment_action_id
620: AND ppa.payroll_action_id = paa.payroll_action_id