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 1246: -- locks ( though PAY_ACTION_INTERLOCKS ) the assignment action.

1242: where paa.assignment_action_id = cp_asg_act_id;
1243:
1244: --
1245: -- A given assignment action is void if there is a payroll action of type 'D'
1246: -- locks ( though PAY_ACTION_INTERLOCKS ) the assignment action.
1247: -- Note that this cursor does not check whether the void assignment action has
1248: -- a status of complete
1249: --
1250: cursor c_is_voided ( p_assignment_action_id in number ) is

Line 1253: pay_action_interlocks intloc,

1249: --
1250: cursor c_is_voided ( p_assignment_action_id in number ) is
1251: select intloc.locking_action_id
1252: from pay_assignment_actions assact,
1253: pay_action_interlocks intloc,
1254: pay_payroll_actions pact
1255: where intloc.locked_action_id = p_assignment_action_id
1256: and intloc.locking_action_id = assact.assignment_action_id
1257: and assact.payroll_action_id = pact.payroll_action_id

Line 1278: pay_action_interlocks pai1,

1274: and ppe.effective_date <= nvl(ppa.date_earned,ppa.effective_date)
1275: )
1276: and not exists (select ''
1277: from pay_assignment_actions paa1, -- Prepay/Costing
1278: pay_action_interlocks pai1,
1279: pay_assignment_actions paa2,-- Payment/Trans GL
1280: pay_action_interlocks pai2
1281: where pai1.locked_action_id = paa.assignment_action_id
1282: and pai1.locking_action_id = paa1.assignment_action_id

Line 1280: pay_action_interlocks pai2

1276: and not exists (select ''
1277: from pay_assignment_actions paa1, -- Prepay/Costing
1278: pay_action_interlocks pai1,
1279: pay_assignment_actions paa2,-- Payment/Trans GL
1280: pay_action_interlocks pai2
1281: where pai1.locked_action_id = paa.assignment_action_id
1282: and pai1.locking_action_id = paa1.assignment_action_id
1283: and pai2.locked_action_id = paa1.assignment_action_id
1284: and pai2.locking_action_id = paa2.assignment_action_id);

Line 1297: pay_action_interlocks pai1

1293: and paa.payroll_action_id = ppa.payroll_action_id
1294: and paa.action_status = 'C'
1295: and not exists (select ''
1296: from pay_assignment_actions paa1, -- Payment/Trans GL
1297: pay_action_interlocks pai1
1298: where pai1.locked_action_id = paa.assignment_action_id
1299: and pai1.locking_action_id = paa1.assignment_action_id)
1300: and (exists (select ''
1301: from pay_process_events ppe

Line 1309: from pay_action_interlocks pai,

1305: and ppe.creation_date > cp_last_cc_run_date
1306: )
1307: or
1308: exists (select ''
1309: from pay_action_interlocks pai,
1310: pay_assignment_actions paa2,
1311: pay_payroll_actions ppa2
1312: where pai.locking_action_id = paa.assignment_action_id
1313: and pai.locked_action_id = paa2.assignment_action_id

Line 1337: pay_action_interlocks pai1

1333: and paa.payroll_action_id = ppa.payroll_action_id
1334: and paa.action_status = 'C'
1335: and not exists (select ''
1336: from pay_assignment_actions paa1, -- Payment/Trans GL
1337: pay_action_interlocks pai1
1338: where pai1.locked_action_id = paa.assignment_action_id
1339: and pai1.locking_action_id = paa1.assignment_action_id)
1340: and exists (select ''
1341: from pay_process_events ppe

Line 1348: from pay_action_interlocks pai,

1344: and ppe.change_type in ('COST_CENTRE')
1345: and ppe.creation_date > cp_last_cc_run_date
1346: )
1347: and exists (select ''
1348: from pay_action_interlocks pai,
1349: pay_assignment_actions paa2,
1350: pay_payroll_actions ppa2
1351: where pai.locking_action_id = paa.assignment_action_id
1352: and pai.locked_action_id = paa2.assignment_action_id