[Home] [Help]
612: and ppa.payroll_action_id = paa.payroll_action_id
613: and ppa.effective_date = cp_effective_date
614: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
615: and not exists (select 1
616: from pay_action_interlocks pai,
617: pay_assignment_actions paa1,
618: pay_payroll_actions ppa1
619: where pai.locked_action_id = paa.assignment_action_id
620: and pai.locking_action_id = paa1.assignment_action_id
648: and ppa.effective_date = cp_effective_date
649: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
650: and not exists
651: ( SELECT pail.locked_action_id
652: FROM pay_action_interlocks pail,
653: pay_payroll_actions pact,
654: pay_assignment_actions passt
655: WHERE pact.report_type in ('PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')
656: AND pact.payroll_action_id = passt.payroll_action_id
712: and ppa.effective_date = cp_effective_date
713: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
714: and exists
715: ( SELECT pail.locked_action_id
716: FROM pay_action_interlocks pail,
717: pay_payroll_actions pact,
718: pay_assignment_actions passt
719: WHERE pact.report_type = 'PAYCAT4AMPDF'
720: AND pact.payroll_action_id = passt.payroll_action_id
766: and ppa.effective_date = cp_effective_date
767: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
768: and not exists
769: ( SELECT pail.locked_action_id
770: FROM pay_action_interlocks pail,
771: pay_payroll_actions pact,
772: pay_assignment_actions passt
773: WHERE pact.report_type in ('PAYCAT4AMPDF','CAEOY_T4_AMEND_PP')
774: AND pact.payroll_action_id = passt.payroll_action_id
810: and ppa.effective_date = cp_effective_date
811: and ppa.report_type = 'CAEOY_T4_AMEND_PP'
812: and exists
813: ( SELECT pail.locked_action_id
814: FROM pay_action_interlocks pail,
815: pay_payroll_actions pact,
816: pay_assignment_actions passt
817: WHERE pact.report_type = 'PAYCAT4AMPDF'
818: AND pact.payroll_action_id = passt.payroll_action_id