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

Line 103: FROM pay_action_interlocks pail,

99: WHERE paf2.assignment_id = paf.assignment_id
100: AND paf2.effective_start_date <= ppa.effective_date)
101: AND NOT EXISTS
102: (SELECT pail.locked_action_id
103: FROM pay_action_interlocks pail,
104: pay_payroll_actions pact,
105: pay_assignment_actions passt
106: WHERE pact.report_type IN ('T4A_AMEND_MAG','MAG_T4A','CAEOY_T4A_AMEND_PP')
107: AND pact.payroll_action_id = passt.payroll_action_id

Line 140: pay_action_interlocks pail,

136: AND NOT EXISTS (
137: SELECT
138: pail.locked_action_id
139: FROM
140: pay_action_interlocks pail,
141: pay_payroll_actions pact,
142: pay_assignment_actions passt
143: WHERE pact.report_type IN ( 'T4A_AMEND_MAG' , 'MAG_T4A' , 'CAEOY_T4A_AMEND_PP' )
144: AND pact.payroll_action_id = passt.payroll_action_id

Line 1291: pay_action_interlocks pai

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