APPS.PAY_CA_EOY_RL2_CANCEL_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 569: from pay_action_interlocks pai,

565: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
566: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
567: 'CAEOY_RL2_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
568: and not exists (select 1
569: from pay_action_interlocks pai,
570: pay_assignment_actions paa1,
571: pay_payroll_actions ppa1
572: where pai.locked_action_id = paa.assignment_action_id
573: and pai.locking_action_id = paa1.assignment_action_id

Line 619: FROM pay_action_interlocks pail,

615: and ppa.effective_date = cp_effective_date
616: and ppa.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
617: and exists
618: ( SELECT pail.locked_action_id
619: FROM pay_action_interlocks pail,
620: pay_payroll_actions ppa1,
621: pay_assignment_actions paa1
622: WHERE ppa1.report_type = 'PAYCARL2CLPDF'
623: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 677: from pay_action_interlocks pai,

673: and nvl(pay_ca_archive_utils.get_archive_value(substr(paa.serial_number,3,14),
674: substr(paa.serial_number,1,2),'JURISDICTION_CODE',
675: 'CAEOY_RL2_NEGATIVE_BALANCE_EXISTS'),'N') = 'N'
676: and not exists (select 1
677: from pay_action_interlocks pai,
678: pay_assignment_actions paa1,
679: pay_payroll_actions ppa1
680: where pai.locked_action_id = paa.assignment_action_id
681: and pai.locking_action_id = paa1.assignment_action_id

Line 730: FROM pay_action_interlocks pail,

726: and ppa.effective_date = cp_effective_date
727: and ppa.report_type in ('RL2PAPERPDF','PAYCARL2AMPDF')
728: and exists
729: ( SELECT pail.locked_action_id
730: FROM pay_action_interlocks pail,
731: pay_payroll_actions ppa1,
732: pay_assignment_actions paa1
733: WHERE ppa1.report_type = 'PAYCARL2CLPDF'
734: AND ppa1.payroll_action_id = paa1.payroll_action_id