APPS.PAY_CA_EOY_T4_CANCEL_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 615: from pay_action_interlocks pai,

611: where paf.assignment_id = paa.assignment_id
612: and paf.effective_start_date <= cp_effective_date
613: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
614: and not exists (select 1
615: from pay_action_interlocks pai,
616: pay_assignment_actions paa1,
617: pay_payroll_actions ppa1
618: where pai.locked_action_id = paa.assignment_action_id
619: and pai.locking_action_id = paa1.assignment_action_id

Line 667: FROM pay_action_interlocks pail,

663: and paf.effective_start_date <= cp_effective_date
664: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
665: and exists
666: ( SELECT pail.locked_action_id
667: FROM pay_action_interlocks pail,
668: pay_payroll_actions ppa1,
669: pay_assignment_actions paa1
670: WHERE ppa1.report_type = 'PAYCAT4CLPDF'
671: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 726: from pay_action_interlocks pai,

722: where paf.assignment_id = paa.assignment_id
723: and paf.effective_start_date <= cp_effective_date
724: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
725: and not exists (select 1
726: from pay_action_interlocks pai,
727: pay_assignment_actions paa1,
728: pay_payroll_actions ppa1
729: where pai.locked_action_id = paa.assignment_action_id
730: and pai.locking_action_id = paa1.assignment_action_id

Line 781: FROM pay_action_interlocks pail,

777: and paf.effective_start_date <= cp_effective_date
778: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
779: and exists
780: ( SELECT pail.locked_action_id
781: FROM pay_action_interlocks pail,
782: pay_payroll_actions ppa1,
783: pay_assignment_actions paa1
784: WHERE ppa1.report_type = 'PAYCAT4CLPDF'
785: AND ppa1.payroll_action_id = paa1.payroll_action_id