APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 155: pay_action_interlocks loc

151: and rpaa.assignment_id = p_assignment_id
152: and rpaa.action_sequence =
153: (select max(aa.action_sequence)
154: from pay_assignment_actions aa,
155: pay_action_interlocks loc
156: where loc.locked_action_id = aa.assignment_action_id
157: and loc.locking_action_id = paa.assignment_action_id);
158:
159: -- Copied from HR_GBBAL.get_latest_action_id, include action type P and U

Line 192: pay_action_interlocks loc

188:
189: cursor csr_formula_5(p_assig_act_id NUMBER) is
190: select assact.assignment_action_id
191: from pay_assignment_actions assact,
192: pay_action_interlocks loc
193: where loc.locking_action_id = p_assignment_action_id
194: and assact.assignment_action_id = loc.locked_action_id
195: order by assact.action_sequence desc;
196:

Line 267: pay_action_interlocks loc

263: cursor csr_formula_2 is
264: -- for prepayment action find the latest interlocked run
265: select assact.assignment_action_id
266: from pay_assignment_actions assact,
267: pay_action_interlocks loc
268: where loc.locking_action_id = p_assignment_action_id
269: and assact.assignment_action_id = loc.locked_action_id
270: order by assact.action_sequence desc
271: ;

Line 277: pay_action_interlocks loc

273: -- for run action check if its been prepaid
274: select assact.assignment_action_id
275: from pay_assignment_actions assact,
276: pay_payroll_actions pact,
277: pay_action_interlocks loc
278: where loc.locked_action_id = p_assignment_action_id
279: and assact.assignment_action_id = loc.locking_action_id
280: and pact.payroll_action_id = assact.payroll_action_id
281: and pact.action_type in ('P','U') /* prepayments only */