APPS.PAY_MX_PAYREG_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 309: FROM pay_action_interlocks pai,

305:
306: CURSOR c_run_eff_date (cp_pre_pymt_action_id IN NUMBER) IS
307: SELECT ppa.effective_date,
308: ppa.action_type
309: FROM pay_action_interlocks pai,
310: pay_assignment_actions paa,
311: pay_payroll_actions ppa
312: WHERE pai.locking_action_id = cp_pre_pymt_action_id
313: AND paa.assignment_action_id = pai.locked_action_id

Line 319: FROM pay_action_interlocks pai,

315: AND ppa.action_type in ('R', 'Q', 'B');
316:
317: CURSOR c_payroll_run (cp_pre_pymt_action_id IN NUMBER) IS
318: SELECT assignment_action_id, ppa.action_type
319: FROM pay_action_interlocks pai,
320: pay_assignment_actions paa,
321: pay_payroll_actions ppa
322: WHERE pai.locking_action_id = cp_pre_pymt_action_id
323: AND paa.assignment_action_id = pai.locked_action_id

Line 340: FROM pay_action_interlocks pai,

336: ORDER BY assignment_action_id DESC;
337:
338: CURSOR c_multi_ba_acts(cp_pre_pymt_action_id IN NUMBER) IS
339: SELECT assignment_action_id, ppa.action_type
340: FROM pay_action_interlocks pai,
341: pay_assignment_actions paa,
342: pay_payroll_actions ppa
343: WHERE pai.locking_action_id = cp_pre_pymt_action_id
344: AND paa.assignment_action_id = pai.locked_action_id

Line 385: pay_action_interlocks pai

381: FROM pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
382: pay_assignment_actions paa1, -- assignment_action for master payroll run
383: pay_run_Types_f prt,
384: pay_payroll_actions ppa,
385: pay_action_interlocks pai
386: WHERE pai.locking_action_id = cp_pre_pymt_action_id
387: AND pai.locked_action_id = paa1.assignment_action_id
388: AND paa1.source_action_id IS NULL -- master assignment_action
389: AND paa1.assignment_action_id = paa2.source_action_id

Line 413: pay_action_interlocks pai

409: pay_assignment_actions paa1,
410: -- assignment_action for master payroll run
411: pay_run_Types_f prt,
412: pay_payroll_actions ppa,
413: pay_action_interlocks pai
414: WHERE pai.locking_action_id = cp_pre_pymt_action_id
415: AND pai.locked_action_id = paa1.assignment_action_id
416: AND paa1.source_action_id is null -- master assignment_action
417: AND paa1.assignment_action_id = paa2.source_action_id

Line 429: FROM pay_action_interlocks pai,

425: GROUP BY paa1.assignment_action_id;
426:
427: CURSOR c_check_for_void (cp_pre_pymt_action_id IN NUMBER) IS
428: SELECT 'Y'
429: FROM pay_action_interlocks pai,
430: pay_assignment_actions paa,
431: pay_payroll_actions ppa
432: WHERE pai.locking_action_id = cp_pre_pymt_action_id
433: AND paa.assignment_action_id = pai.locked_action_id