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

Line 166: from pay_action_interlocks pai

162: and paa.payroll_action_id = ppa.payroll_action_id
163: and ppa.action_type = 'C'
164: and ppa.effective_date >= p_effdate
165: and not exists (select ''
166: from pay_action_interlocks pai
167: where pai.locked_action_id = paa.assignment_action_id)
168: order by paa.action_sequence desc;
169: --
170: cursor get_prepay(p_assact_id number, p_effdate date) is

Line 182: from pay_action_interlocks pai

178: and paa.payroll_action_id = ppa.payroll_action_id
179: and ppa.action_type in ('P', 'U')
180: and ppa.effective_date >= p_effdate
181: and not exists (select ''
182: from pay_action_interlocks pai
183: where pai.locked_action_id = paa.assignment_action_id)
184: order by paa.action_sequence desc;
185: --
186: cursor get_run(p_assact_id number, p_effdate date) is

Line 201: from pay_action_interlocks pai,

197: and paa.source_action_id is null
198: and ppa.action_type in ('R', 'Q','V','B')
199: and ppa.effective_date >= p_effdate
200: and not exists (select ''
201: from pay_action_interlocks pai,
202: pay_assignment_actions paa2,
203: pay_payroll_actions ppa2,
204: pay_action_interlocks pai2
205: where pai.locked_action_id = paa.assignment_action_id

Line 204: pay_action_interlocks pai2

200: and not exists (select ''
201: from pay_action_interlocks pai,
202: pay_assignment_actions paa2,
203: pay_payroll_actions ppa2,
204: pay_action_interlocks pai2
205: where pai.locked_action_id = paa.assignment_action_id
206: and pai.locking_action_id = paa2.assignment_action_id
207: and paa2.payroll_action_id = ppa2.payroll_action_id
208: and ppa2.action_type in ('P', 'U', 'C')

Line 235: from pay_action_interlocks pai,

231: and pa2.action_type = acl.action_type
232: and pa2.action_type in ('R', 'Q','V','B')
233: and ac2.action_sequence > paa.action_sequence
234: and exists (select ''
235: from pay_action_interlocks pai,
236: pay_assignment_actions paa2,
237: pay_payroll_actions ppa2,
238: pay_action_interlocks pai2
239: where pai.locked_action_id = ac2.assignment_action_id

Line 238: pay_action_interlocks pai2

234: and exists (select ''
235: from pay_action_interlocks pai,
236: pay_assignment_actions paa2,
237: pay_payroll_actions ppa2,
238: pay_action_interlocks pai2
239: where pai.locked_action_id = ac2.assignment_action_id
240: and pai.locking_action_id = paa2.assignment_action_id
241: and paa2.payroll_action_id = ppa2.payroll_action_id
242: and ppa2.action_type in ('P', 'U', 'C')

Line 251: pay_action_interlocks pai,

247: --
248: cursor get_locked_actions (p_assact_id number) is
249: select paa.assignment_action_id
250: from pay_assignment_actions paa,
251: pay_action_interlocks pai,
252: pay_payroll_actions ppa
253: where pai.locked_action_id = p_assact_id
254: and pai.locking_action_id = paa.assignment_action_id
255: and paa.payroll_action_id = ppa.payroll_action_id

Line 286: from pay_action_interlocks pai,

282: and paa.source_action_id is null
283: and ppa.action_type in ('R', 'Q')
284: and not exists (
285: select 1
286: from pay_action_interlocks pai,
287: pay_assignment_actions paa2,
288: pay_payroll_actions ppa2,
289: pay_action_interlocks pai2
290: where pai.locked_action_id = paa.assignment_action_id

Line 289: pay_action_interlocks pai2

285: select 1
286: from pay_action_interlocks pai,
287: pay_assignment_actions paa2,
288: pay_payroll_actions ppa2,
289: pay_action_interlocks pai2
290: where pai.locked_action_id = paa.assignment_action_id
291: and pai.locking_action_id = paa2.assignment_action_id
292: and paa2.payroll_action_id = ppa2.payroll_action_id
293: and ppa2.action_type in ('P', 'U', 'C')

Line 1194: -- locks ( though PAY_ACTION_INTERLOCKS ) the assignment action.

1190: where paa.assignment_action_id = cp_asg_act_id;
1191:
1192: --
1193: -- A given assignment action is void if there is a payroll action of type 'D'
1194: -- locks ( though PAY_ACTION_INTERLOCKS ) the assignment action.
1195: -- Note that this cursor does not check whether the void assignment action has
1196: -- a status of complete
1197: --
1198: cursor c_is_voided ( p_assignment_action_id in number ) is

Line 1201: pay_action_interlocks intloc,

1197: --
1198: cursor c_is_voided ( p_assignment_action_id in number ) is
1199: select intloc.locking_action_id
1200: from pay_assignment_actions assact,
1201: pay_action_interlocks intloc,
1202: pay_payroll_actions pact
1203: where intloc.locked_action_id = p_assignment_action_id
1204: and intloc.locking_action_id = assact.assignment_action_id
1205: and assact.payroll_action_id = pact.payroll_action_id

Line 1226: pay_action_interlocks pai1,

1222: and ppe.effective_date <= nvl(ppa.date_earned,ppa.effective_date)
1223: )
1224: and not exists (select ''
1225: from pay_assignment_actions paa1, -- Prepay/Costing
1226: pay_action_interlocks pai1,
1227: pay_assignment_actions paa2,-- Payment/Trans GL
1228: pay_action_interlocks pai2
1229: where pai1.locked_action_id = paa.assignment_action_id
1230: and pai1.locking_action_id = paa1.assignment_action_id

Line 1228: pay_action_interlocks pai2

1224: and not exists (select ''
1225: from pay_assignment_actions paa1, -- Prepay/Costing
1226: pay_action_interlocks pai1,
1227: pay_assignment_actions paa2,-- Payment/Trans GL
1228: pay_action_interlocks pai2
1229: where pai1.locked_action_id = paa.assignment_action_id
1230: and pai1.locking_action_id = paa1.assignment_action_id
1231: and pai2.locked_action_id = paa1.assignment_action_id
1232: and pai2.locking_action_id = paa2.assignment_action_id);

Line 1245: pay_action_interlocks pai1

1241: and paa.payroll_action_id = ppa.payroll_action_id
1242: and paa.action_status = 'C'
1243: and not exists (select ''
1244: from pay_assignment_actions paa1, -- Payment/Trans GL
1245: pay_action_interlocks pai1
1246: where pai1.locked_action_id = paa.assignment_action_id
1247: and pai1.locking_action_id = paa1.assignment_action_id)
1248: and (exists (select ''
1249: from pay_process_events ppe

Line 1257: from pay_action_interlocks pai,

1253: and ppe.creation_date > cp_last_cc_run_date
1254: )
1255: or
1256: exists (select ''
1257: from pay_action_interlocks pai,
1258: pay_assignment_actions paa2,
1259: pay_payroll_actions ppa2
1260: where pai.locking_action_id = paa.assignment_action_id
1261: and pai.locked_action_id = paa2.assignment_action_id

Line 1285: pay_action_interlocks pai1

1281: and paa.payroll_action_id = ppa.payroll_action_id
1282: and paa.action_status = 'C'
1283: and not exists (select ''
1284: from pay_assignment_actions paa1, -- Payment/Trans GL
1285: pay_action_interlocks pai1
1286: where pai1.locked_action_id = paa.assignment_action_id
1287: and pai1.locking_action_id = paa1.assignment_action_id)
1288: and exists (select ''
1289: from pay_process_events ppe

Line 1296: from pay_action_interlocks pai,

1292: and ppe.change_type in ('COST_CENTRE')
1293: and ppe.creation_date > cp_last_cc_run_date
1294: )
1295: and exists (select ''
1296: from pay_action_interlocks pai,
1297: pay_assignment_actions paa2,
1298: pay_payroll_actions ppa2
1299: where pai.locking_action_id = paa.assignment_action_id
1300: and pai.locked_action_id = paa2.assignment_action_id