APPS.PAY_SG_SOE dependencies on PAY_ACTION_INTERLOCKS

Line 160: from pay_action_interlocks

156: /* Bug:2883606. Cursor to get all the locked actions locked by prepayments */
157: cursor run_ids
158: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
159: select LOCKED_ACTION_ID
160: from pay_action_interlocks
161: where LOCKING_ACTION_ID = p_assignment_action_id
162: order by locked_action_id asc;
163:
164: /* Bug#2883606. Included check for costing(C) */

Line 170: from pay_action_interlocks pai,

166: /* whatever Costing runs after prepayment or before */
167: cursor c_lock_id
168: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
169: select pai.locking_action_id
170: from pay_action_interlocks pai,
171: pay_payroll_actions ppa,
172: pay_assignment_actions paa
173: where pai.locked_action_id = c_assign_act_id
174: and paa.assignment_action_id=pai.locking_action_id

Line 394: from pay_action_interlocks

390: /* Bug:2883606. Cursor to get all the locked actions locked by prepayments */
391: cursor run_ids
392: (p_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
393: select LOCKED_ACTION_ID
394: from pay_action_interlocks
395: where LOCKING_ACTION_ID = p_assignment_action_id
396: order by locked_action_id asc;
397:
398: /* Bug#2883606. Included check for costing(C) */

Line 402: from pay_action_interlocks pai,

398: /* Bug#2883606. Included check for costing(C) */
399: cursor c_lock_id
400: (c_assign_act_id pay_assignment_actions.assignment_action_id%type) is
401: select pai.locking_action_id
402: from pay_action_interlocks pai,
403: pay_payroll_actions ppa,
404: pay_assignment_actions paa
405: where pai.locked_action_id = c_assign_act_id
406: and paa.assignment_action_id=pai.locking_action_id