APPS.PAY_CA_EOY_T4A_CANCEL_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 577: from pay_action_interlocks pai,

573: where paf.assignment_id = paa.assignment_id
574: and paf.effective_start_date <= cp_effective_date
575: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
576: and not exists (select 1
577: from pay_action_interlocks pai,
578: pay_assignment_actions paa1,
579: pay_payroll_actions ppa1
580: where pai.locked_action_id = paa.assignment_action_id
581: and pai.locking_action_id = paa1.assignment_action_id

Line 629: FROM pay_action_interlocks pail,

625: and paf.effective_start_date <= cp_effective_date
626: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
627: and exists
628: ( SELECT pail.locked_action_id
629: FROM pay_action_interlocks pail,
630: pay_payroll_actions ppa1,
631: pay_assignment_actions paa1
632: WHERE ppa1.report_type = 'PAYCAT4ACLPDF'
633: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 686: from pay_action_interlocks pai,

682: where paf.assignment_id = paa.assignment_id
683: and paf.effective_start_date <= cp_effective_date
684: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
685: and not exists (select 1
686: from pay_action_interlocks pai,
687: pay_assignment_actions paa1,
688: pay_payroll_actions ppa1
689: where pai.locked_action_id = paa.assignment_action_id
690: and pai.locking_action_id = paa1.assignment_action_id

Line 741: FROM pay_action_interlocks pail,

737: and paf.effective_start_date <= cp_effective_date
738: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
739: and exists
740: ( SELECT pail.locked_action_id
741: FROM pay_action_interlocks pail,
742: pay_payroll_actions ppa1,
743: pay_assignment_actions paa1
744: WHERE ppa1.report_type = 'PAYCAT4ACLPDF'
745: AND ppa1.payroll_action_id = paa1.payroll_action_id