eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PAY_ACTION_INTERLOCKS

Line 579: from pay_action_interlocks pai,

575: and ppa.payroll_action_id = paa.payroll_action_id
576: and ppa.effective_date = cp_effective_date
577: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
578: and not exists (select 1
579: from pay_action_interlocks pai,
580: pay_assignment_actions paa1,
581: pay_payroll_actions ppa1
582: where pai.locked_action_id = paa.assignment_action_id
583: and pai.locking_action_id = paa1.assignment_action_id

Line 614: FROM pay_action_interlocks pail,

610: and ppa.effective_date = cp_effective_date
611: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
612: and not exists
613: ( SELECT pail.locked_action_id
614: FROM pay_action_interlocks pail,
615: pay_payroll_actions pact,
616: pay_assignment_actions passt
617: WHERE pact.report_type IN ('PAYCAT4AAMPDF','CAEOY_T4A_AMEND_PP') -- #10352779
618: AND pact.payroll_action_id = passt.payroll_action_id

Line 677: FROM pay_action_interlocks pail,

673: and ppa.effective_date = cp_effective_date
674: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
675: and exists
676: ( SELECT pail.locked_action_id
677: FROM pay_action_interlocks pail,
678: pay_payroll_actions pact,
679: pay_assignment_actions passt
680: WHERE pact.report_type = 'PAYCAT4AAMPDF'
681: AND pact.payroll_action_id = passt.payroll_action_id

Line 730: FROM pay_action_interlocks pail,

726: and ppa.effective_date = cp_effective_date
727: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
728: and not exists
729: ( SELECT pail.locked_action_id
730: FROM pay_action_interlocks pail,
731: pay_payroll_actions pact,
732: pay_assignment_actions passt
733: WHERE pact.report_type IN ('PAYCAT4AAMPDF','CAEOY_T4A_AMEND_PP') -- #10352779
734: AND pact.payroll_action_id = passt.payroll_action_id

Line 773: FROM pay_action_interlocks pail,

769: and ppa.effective_date = cp_effective_date
770: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
771: and exists
772: ( SELECT pail.locked_action_id
773: FROM pay_action_interlocks pail,
774: pay_payroll_actions pact,
775: pay_assignment_actions passt
776: WHERE pact.report_type = 'PAYCAT4AAMPDF'
777: AND pact.payroll_action_id = passt.payroll_action_id