APPS.PAY_PAYRG_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 384: from pay_action_interlocks pai,

380:
381: cursor c_run_eff_date (cp_pre_pymt_action_id in number) is
382: select ppa.effective_date,
383: ppa.action_type
384: from pay_action_interlocks pai,
385: pay_assignment_actions paa,
386: pay_payroll_actions ppa
387: where pai.locking_action_id = cp_pre_pymt_action_id
388: and paa.assignment_action_id = pai.locked_action_id

Line 394: from pay_action_interlocks pai,

390: and ppa.action_type in ('R', 'Q', 'B');
391:
392: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
393: select assignment_action_id, ppa.action_type
394: from pay_action_interlocks pai,
395: pay_assignment_actions paa,
396: pay_payroll_actions ppa
397: where pai.locking_action_id = cp_pre_pymt_action_id
398: and paa.assignment_action_id = pai.locked_action_id

Line 416: from pay_action_interlocks pai,

412:
413: -- Bug 4074976 -- Added a new cursor for Balance Adjustments for multiple assignment payroll.
414: cursor c_multi_ba_acts(cp_pre_pymt_action_id in number) is
415: select assignment_action_id, ppa.action_type
416: from pay_action_interlocks pai,
417: pay_assignment_actions paa,
418: pay_payroll_actions ppa
419: where pai.locking_action_id = cp_pre_pymt_action_id
420: and paa.assignment_action_id = pai.locked_action_id

Line 461: pay_action_interlocks pai

457: from pay_assignment_actions paa2, -- assignment_actions for slave payroll runs.
458: pay_assignment_actions paa1, -- assignment_action for master payroll run
459: pay_run_Types_f prt,
460: pay_payroll_actions ppa,
461: pay_action_interlocks pai
462: where pai.locking_action_id = cp_pre_pymt_action_id
463: and pai.locked_action_id = paa1.assignment_action_id
464: and paa1.source_action_id is null -- master assignment_action
465: and paa1.assignment_action_id = paa2.source_action_id

Line 489: pay_action_interlocks pai

485: pay_assignment_actions paa1,
486: -- assignment_action for master payroll run
487: pay_run_Types_f prt,
488: pay_payroll_actions ppa,
489: pay_action_interlocks pai
490: where pai.locking_action_id = cp_pre_pymt_action_id
491: and pai.locked_action_id = paa1.assignment_action_id
492: and paa1.source_action_id is null -- master assignment_action
493: and paa1.assignment_action_id = paa2.source_action_id

Line 505: from pay_action_interlocks pai,

501: group by paa1.assignment_action_id;
502:
503: cursor c_check_for_void (cp_pre_pymt_action_id in number) is
504: select 'Y'
505: from pay_action_interlocks pai,
506: pay_assignment_actions paa,
507: pay_payroll_actions ppa
508: where pai.locking_action_id = cp_pre_pymt_action_id
509: and paa.assignment_action_id = pai.locked_action_id