APPS.PAY_CA_PAYRG_PKG dependencies on PAY_ACTION_INTERLOCKS

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

75: from pay_assignment_actions act,
76: per_assignments_f asg,
77: pay_payroll_actions ppa2, /* run and quickpay payroll actions */
78: pay_assignment_actions act2, /* run and quickpay assignment actions */
79: pay_action_interlocks pai, /* interlocks table */
80: pay_payroll_actions ppa, /* PYUGEN information */
81: pay_payroll_actions pa1 /* Payroll Register information */
82: where ppa.payroll_action_id = :payroll_action_id
83: and pa1.consolidation_set_id =

Line 179: from pay_action_interlocks pai1

175: -- changes ended for bug 5152897
176: )
177: and ( ( ppa.action_type in ('P','U') and
178: ( exists ( select 1
179: from pay_action_interlocks pai1
180: ,pay_assignment_actions paa1
181: ,pay_payroll_actions ppa2
182: where pai1.locking_action_id = act.assignment_action_id
183: and paa1.assignment_action_id = pai1.locked_action_id

Line 233: from pay_action_interlocks pai

229: and paa.tax_unit_id = cp_tax_unit_id;
230:
231: cursor c_pp_aaid_for_sepchk(cp_source_action_id number) is
232: select paa.assignment_action_id
233: from pay_action_interlocks pai
234: ,pay_assignment_actions paa
235: ,pay_payroll_actions ppa
236: where pai.locked_action_id = cp_source_action_id
237: and paa.assignment_action_id = pai.locking_action_id

Line 248: pay_action_interlocks pai,

244: cp_tax_unit_id number,
245: cp_sepchk_run_tp_id number) is
246: select max(paa.assignment_action_id)
247: from pay_assignment_actions paa,
248: pay_action_interlocks pai,
249: pay_run_types_f prt,
250: pay_payroll_actions ppa
251: where pai.locking_action_id = cp_prepay_action_id
252: and paa.assignment_action_id = pai.locked_action_id

Line 267: pay_action_interlocks pai,

263: cp_assignment_id number,
264: cp_sepchk_run_tp_id number) is
265: select max(paa.assignment_action_id)
266: from pay_assignment_actions paa,
267: pay_action_interlocks pai,
268: pay_run_types_f prt,
269: pay_payroll_actions ppa
270: where pai.locking_action_id = cp_prepay_action_id
271: and paa.assignment_action_id = pai.locked_action_id

Line 304: from pay_action_interlocks pai,

300: cursor c_multi_asg_max_aaid(cp_prepay_asg_act_id number
301: ,cp_assignment_id number
302: ,cp_action_sequence number) is
303: select paa_run.action_sequence, paa_run.assignment_action_id
304: from pay_action_interlocks pai,
305: pay_assignment_actions paa_run,
306: pay_payroll_actions ppa_run,
307: pay_run_types_f prt
308: where pai.locking_action_id = cp_prepay_asg_act_id