DBA Data[Home] [Help]

APPS.PAY_IP_UTILITY dependencies on PAY_PAYROLL_ACTIONS

Line 604: pay_payroll_actions ppa_pymt,

600: 'M', 'Direct Deposit',
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

Line 614: FROM pay_payroll_actions ppa,

610: AND paa_pymt.pre_payment_id = cp_pre_payment_id
611: AND ppp.pre_payment_id = paa_pymt.pre_payment_id
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 */