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_T4_AMEND_MAG dependencies on PAY_ACTION_INTERLOCKS

Line 101: FROM pay_action_interlocks pail,

97: WHERE paf2.assignment_id = paf.assignment_id
98: AND paf2.effective_start_date <= ppa.effective_date)
99: AND NOT EXISTS
100: (SELECT pail.locked_action_id
101: FROM pay_action_interlocks pail,
102: pay_payroll_actions pact,
103: pay_assignment_actions passt
104: WHERE pact.report_type IN ('T4_AMEND_MAG','PYT4MAG','CAEOY_T4_AMEND_PP')
105: AND pact.payroll_action_id = passt.payroll_action_id

Line 138: pay_action_interlocks pail,

134: AND NOT EXISTS (
135: SELECT
136: pail.locked_action_id
137: FROM
138: pay_action_interlocks pail,
139: pay_payroll_actions pact,
140: pay_assignment_actions passt
141: WHERE pact.report_type IN ( 'T4_AMEND_MAG' , 'PYT4MAG' , 'CAEOY_T4_AMEND_PP' )
142: AND pact.payroll_action_id = passt.payroll_action_id

Line 1290: pay_action_interlocks pai

1286: paa.assignment_action_id,
1287: paa.payroll_action_id
1288: FROM pay_assignment_actions paa,
1289: pay_payroll_actions ppa,
1290: pay_action_interlocks pai
1291: WHERE pai.locking_action_id = p_assg_actid
1292: AND pai.locked_action_id = paa.assignment_action_id
1293: AND ppa.payroll_action_id = paa.payroll_action_id
1294: AND ppa.report_type = 'CAEOY_T4_AMEND_PP'