APPS.PAY_JP_SOE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 260: pay_action_interlocks pai

256: ppa.action_type,
257: ppa.effective_date
258: from pay_payroll_actions ppa,
259: pay_assignment_actions paa,
260: pay_action_interlocks pai
261: where pai.locked_action_id = p_locked_action_id
262: and paa.assignment_action_id = pai.locking_action_id
263: and ppa.payroll_action_id = paa.payroll_action_id
264: and ppa.action_type = p_locking_action_type;

Line 274: pay_action_interlocks pai

270: ppa.action_type,
271: ppa.effective_date
272: from pay_payroll_actions ppa,
273: pay_assignment_actions paa,
274: pay_action_interlocks pai
275: where pai.locked_action_id = p_locked_action_id
276: and paa.assignment_action_id = pai.locking_action_id
277: and ppa.payroll_action_id = paa.payroll_action_id
278: and ppa.action_type in ('P','U');

Line 295: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2)

291: where paa.pre_payment_id = p_locked_action_id
292: and ppa.payroll_action_id = paa.payroll_action_id
293: and not exists(
294: select /*+ ORDERED
295: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2)
296: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_PK)
297: INDEX(PPA2 PAY_PAYROLL_ACTIONS_PK) */
298: NULL
299: from pay_action_interlocks pai,

Line 299: from pay_action_interlocks pai,

295: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2)
296: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_PK)
297: INDEX(PPA2 PAY_PAYROLL_ACTIONS_PK) */
298: NULL
299: from pay_action_interlocks pai,
300: pay_assignment_actions paa2,
301: pay_payroll_actions ppa2
302: where pai.locked_action_id = paa.assignment_action_id
303: and paa2.assignment_action_id = pai.locking_action_id

Line 351: pay_action_interlocks pai

347: max(decode(paa.action_status,'C',NULL,'E',2,1)) returns NULL. */
348: decode(max(decode(paa.action_status,'C',NULL,'E',2,1)),NULL,'C',1,'I','E')
349: from pay_payroll_actions ppa,
350: pay_assignment_actions paa,
351: pay_action_interlocks pai
352: where pai.locked_action_id = p_locked_action_id
353: and paa.assignment_action_id = pai.locking_action_id
354: and ppa.payroll_action_id = paa.payroll_action_id
355: and ppa.action_type = p_locking_action_type;

Line 362: pay_action_interlocks pai,

358: select decode(count(decode(ppa2.payroll_action_id,NULL,paa.assignment_action_id,NULL)),count(distinct ppp.pre_payment_id),'C',0,'U','I'),
359: decode(max(decode(decode(ppa2.payroll_action_id,NULL,paa.action_status,NULL),'C',NULL,NULL,NULL,'E',2,1)),NULL,'C',1,'I','E')
360: from pay_payroll_actions ppa2,
361: pay_assignment_actions paa2,
362: pay_action_interlocks pai,
363: pay_assignment_actions paa,
364: pay_pre_payments ppp
365: where ppp.assignment_action_id = p_locked_action_id
366: and paa.pre_payment_id(+) = ppp.pre_payment_id