DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on PAY_ACTION_INTERLOCKS

Line 604: FROM pay_action_interlocks pail,

600: and paf.effective_start_date <= cp_effective_date
601: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
602: AND not exists
603: ( SELECT pail.locked_action_id
604: FROM pay_action_interlocks pail,
605: pay_payroll_actions pact,
606: pay_assignment_actions passt
607: WHERE pact.report_type in (decode(lv_ppr_report_type,'PAYCARL1AMPDF','PAYCARL1AMPDF','PYRL1PRAMEND'),'CAEOY_RL1_AMEND_PP')/*Added for Bug#5046006*/
608: AND pact.payroll_action_id = passt.payroll_action_id

Line 684: FROM pay_action_interlocks pail,

680: and paf.effective_start_date <= cp_effective_date
681: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
682: and exists
683: ( SELECT pail.locked_action_id
684: FROM pay_action_interlocks pail,
685: pay_payroll_actions pact,
686: pay_assignment_actions passt
687: WHERE pact.report_type = decode(lv_ppr_report_type,'PAYCARL1AMPDF','PAYCARL1AMPDF','PYRL1PRAMEND')
688: AND pact.payroll_action_id = passt.payroll_action_id

Line 747: FROM pay_action_interlocks pail,

743: and paf.effective_start_date <= cp_effective_date
744: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
745: AND not exists
746: ( SELECT pail.locked_action_id
747: FROM pay_action_interlocks pail,
748: pay_payroll_actions pact,
749: pay_assignment_actions passt
750: WHERE pact.report_type in (decode(lv_ppr_report_type,'PAYCARL1AMPDF','PAYCARL1AMPDF','PYRL1PRAMEND'),'CAEOY_RL1_AMEND_PP')/*Added for Bug#5046006*/
751: AND pact.payroll_action_id = passt.payroll_action_id

Line 800: FROM pay_action_interlocks pail,

796: and paf.effective_start_date <= cp_effective_date
797: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
798: and exists
799: ( SELECT pail.locked_action_id
800: FROM pay_action_interlocks pail,
801: pay_payroll_actions pact,
802: pay_assignment_actions passt
803: WHERE pact.report_type = decode(lv_ppr_report_type,'PAYCARL1AMPDF','PAYCARL1AMPDF','PYRL1PRAMEND')
804: AND pact.payroll_action_id = passt.payroll_action_id