APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 574: from pay_action_interlocks pai,

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

Line 627: FROM pay_action_interlocks pail,

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

Line 688: from pay_action_interlocks pai,

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

Line 744: FROM pay_action_interlocks pail,

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