DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PAY_ACTION_INTERLOCKS

Line 584: FROM pay_action_interlocks pail,

580: and paf.effective_start_date <= cp_effective_date
581: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
582: AND not exists
583: ( SELECT pail.locked_action_id
584: FROM pay_action_interlocks pail,
585: pay_payroll_actions pact,
586: pay_assignment_actions passt
587: WHERE pact.report_type in (decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND'),'CAEOY_RL2_AMEND_PP')/*Added for Bug#5046010*/
588: AND pact.payroll_action_id = passt.payroll_action_id

Line 664: FROM pay_action_interlocks pail,

660: and paf.effective_start_date <= cp_effective_date
661: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
662: and exists
663: ( SELECT pail.locked_action_id
664: FROM pay_action_interlocks pail,
665: pay_payroll_actions pact,
666: pay_assignment_actions passt
667: WHERE pact.report_type = decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND')
668: AND pact.payroll_action_id = passt.payroll_action_id

Line 728: FROM pay_action_interlocks pail,

724: and paf.effective_start_date <= cp_effective_date
725: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
726: AND not exists
727: ( SELECT pail.locked_action_id
728: FROM pay_action_interlocks pail,
729: pay_payroll_actions pact,
730: pay_assignment_actions passt
731: WHERE pact.report_type in (decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND'),'CAEOY_RL2_AMEND_PP')/*Added for Bug#5046010*/
732: AND pact.payroll_action_id = passt.payroll_action_id

Line 780: FROM pay_action_interlocks pail,

776: and paf.effective_start_date <= cp_effective_date
777: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
778: and exists
779: ( SELECT pail.locked_action_id
780: FROM pay_action_interlocks pail,
781: pay_payroll_actions pact,
782: pay_assignment_actions passt
783: WHERE pact.report_type = decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND')
784: AND pact.payroll_action_id = passt.payroll_action_id