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 162: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)

158: and ppa.action_type in ('R', 'Q', 'B', 'I')
159: and not exists(
160: select /*+ ORDERED
161: USE_NL(PAAA PPAA)
162: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)
163: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
164: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
165: null
166: from pay_action_interlocks xpai,

Line 166: from pay_action_interlocks xpai,

162: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)
163: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
164: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
165: null
166: from pay_action_interlocks xpai,
167: pay_assignment_actions xpaa,
168: pay_payroll_actions xppa
169: where xpai.locked_action_id = paa.assignment_action_id
170: and xpaa.assignment_action_id = xpai.locking_action_id

Line 238: from pay_action_interlocks

234: l_retcode varchar2(10);
235: --
236: cursor csr is
237: select locked_action_id
238: from pay_action_interlocks
239: where locking_action_id = p_assignment_action_id;
240: begin
241: hr_utility.set_location('Entering: ' || c_proc, 10);
242: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);