APPS.PAY_JP_PRE_TAX_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 26: delete pay_action_interlocks

22: is
23: --
24: begin
25: --
26: delete pay_action_interlocks
27: where locking_action_id in (
28: select assignment_action_id
29: from pay_assignment_actions
30: where payroll_action_id = p_payroll_action_id);

Line 171: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)

167: and ppa.action_type in ('R', 'Q', 'B', 'I')
168: and not exists(
169: select /*+ ORDERED
170: USE_NL(PAAA PPAA)
171: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)
172: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
173: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
174: null
175: from pay_action_interlocks xpai,

Line 175: from pay_action_interlocks xpai,

171: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)
172: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
173: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
174: null
175: from pay_action_interlocks xpai,
176: pay_assignment_actions xpaa,
177: pay_payroll_actions xppa
178: where xpai.locked_action_id = paa.assignment_action_id
179: and xpaa.assignment_action_id = xpai.locking_action_id

Line 248: from pay_action_interlocks

244: error_message boolean;
245: --
246: cursor csr is
247: select locked_action_id
248: from pay_action_interlocks
249: where locking_action_id = p_assignment_action_id;
250: begin
251: hr_utility.set_location('Entering: ' || c_proc, 10);
252: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);