APPS.PAY_CA_PAYRG_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 84: pay_action_interlocks pai, /* interlocks table */

80: from pay_assignment_actions act,
81: per_assignments_f asg,
82: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
83: pay_assignment_actions act2, /* run and quickpay assignment actions */
84: pay_action_interlocks pai, /* interlocks table */
85: pay_payroll_actions ppa, /* PYUGEN information */
86: pay_payroll_actions pa1 /* Payroll Register information */
87: where ppa.payroll_action_id = :payroll_action_id
88: and pa1.consolidation_set_id =

Line 184: from pay_action_interlocks pai1

180: -- changes ended for bug 5152897
181: )
182: and ( ( ppa.action_type in ('P','U') and
183: ( exists ( select 1
184: from pay_action_interlocks pai1
185: ,pay_assignment_actions paa1
186: ,pay_payroll_actions ppa2
187: where pai1.locking_action_id = act.assignment_action_id
188: and paa1.assignment_action_id = pai1.locked_action_id

Line 238: from pay_action_interlocks pai

234: and paa.tax_unit_id = cp_tax_unit_id;
235:
236: cursor c_pp_aaid_for_sepchk(cp_source_action_id number) is
237: select paa.assignment_action_id
238: from pay_action_interlocks pai
239: ,pay_assignment_actions paa
240: ,pay_payroll_actions ppa
241: where pai.locked_action_id = cp_source_action_id
242: and paa.assignment_action_id = pai.locking_action_id

Line 253: pay_action_interlocks pai,

249: cp_tax_unit_id number,
250: cp_sepchk_run_tp_id number) is
251: select max(paa.assignment_action_id)
252: from pay_assignment_actions paa,
253: pay_action_interlocks pai,
254: pay_run_types_f prt,
255: pay_payroll_actions ppa
256: where pai.locking_action_id = cp_prepay_action_id
257: and paa.assignment_action_id = pai.locked_action_id

Line 272: pay_action_interlocks pai,

268: cp_assignment_id number,
269: cp_sepchk_run_tp_id number) is
270: select max(paa.assignment_action_id)
271: from pay_assignment_actions paa,
272: pay_action_interlocks pai,
273: pay_run_types_f prt,
274: pay_payroll_actions ppa
275: where pai.locking_action_id = cp_prepay_action_id
276: and paa.assignment_action_id = pai.locked_action_id

Line 309: from pay_action_interlocks pai,

305: cursor c_multi_asg_max_aaid(cp_prepay_asg_act_id number
306: ,cp_assignment_id number
307: ,cp_action_sequence number) is
308: select paa_run.action_sequence, paa_run.assignment_action_id
309: from pay_action_interlocks pai,
310: pay_assignment_actions paa_run,
311: pay_payroll_actions ppa_run,
312: pay_run_types_f prt
313: where pai.locking_action_id = cp_prepay_asg_act_id