APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 308: from pay_action_interlocks pai_mag,

304: select 1
305: from dual
306: where exists
307: (select 1
308: from pay_action_interlocks pai_mag,
309: pay_assignment_actions paa_mag,
310: pay_payroll_actions ppa_mag,
311: pay_org_payment_methods_f popm,
312: pay_pre_payments ppp,

Line 392: from pay_action_interlocks paci,

388: ** we get it from interlocks.
389: ****************************************************************/
390: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
391: select paa.assignment_action_id
392: from pay_action_interlocks paci,
393: pay_assignment_actions paa,
394: pay_payroll_actions ppa
395: where paci.locking_action_id = cp_assignment_action_id
396: and paa.assignment_action_id = paci.locked_action_id

Line 409: from pay_action_interlocks pai_run,

405: ** means there is a seperate check.
406: * ***************************************************************/
407: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
408: select paa_pre.assignment_action_id
409: from pay_action_interlocks pai_run,
410: pay_action_interlocks pai_pre,
411: pay_assignment_actions paa_pre,
412: pay_payroll_actions ppa_pre
413: where pai_run.locking_action_id = cp_assignment_action_id

Line 410: pay_action_interlocks pai_pre,

406: * ***************************************************************/
407: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
408: select paa_pre.assignment_action_id
409: from pay_action_interlocks pai_run,
410: pay_action_interlocks pai_pre,
411: pay_assignment_actions paa_pre,
412: pay_payroll_actions ppa_pre
413: where pai_run.locking_action_id = cp_assignment_action_id
414: and pai_pre.locked_action_id = pai_run.locked_action_id

Line 462: from pay_action_interlocks pai_run, --Pre > Run

458: INTO lv_rev_run_exists
459: FROM dual
460: where exists
461: (Select /*+ ORDERED */ 1
462: from pay_action_interlocks pai_run, --Pre > Run
463: pay_action_interlocks pai_rev, --Run > Rev
464: pay_assignment_actions paa_rev, --Rev
465: pay_payroll_actions ppa_rev --Rev
466: where pai_run.locking_action_id = ln_prepay_action_id

Line 463: pay_action_interlocks pai_rev, --Run > Rev

459: FROM dual
460: where exists
461: (Select /*+ ORDERED */ 1
462: from pay_action_interlocks pai_run, --Pre > Run
463: pay_action_interlocks pai_rev, --Run > Rev
464: pay_assignment_actions paa_rev, --Rev
465: pay_payroll_actions ppa_rev --Rev
466: where pai_run.locking_action_id = ln_prepay_action_id
467: and pai_rev.locked_action_id = pai_run.locked_action_id

Line 513: pay_action_interlocks pai_pre

509: paa_xfr.tax_unit_id
510: from
511: pay_payroll_actions ppa_xfr,
512: pay_assignment_actions paa_xfr,
513: pay_action_interlocks pai_pre
514: where ppa_xfr.report_type = 'XFR_INTERFACE'
515: and ppa_xfr.report_category = 'RT'
516: and ppa_xfr.report_qualifier = 'FED'
517: and cp_deposit_end_date between ppa_xfr.start_date

Line 544: from pay_action_interlocks pai_run, --Pre > Run

540: cp_deposit_end_date,
541: cp_consolidation_set_id) = 'Y' --Bug 3512116
542: and not exists
543: (Select /*+ ORDERED */ 1
544: from pay_action_interlocks pai_run, --Pre > Run
545: pay_action_interlocks pai_rev, --Run > Rev
546: pay_assignment_actions paa_rev, --Rev
547: pay_payroll_actions ppa_rev --Rev
548: where pai_run.locking_action_id = pai_pre.locked_action_id

Line 545: pay_action_interlocks pai_rev, --Run > Rev

541: cp_consolidation_set_id) = 'Y' --Bug 3512116
542: and not exists
543: (Select /*+ ORDERED */ 1
544: from pay_action_interlocks pai_run, --Pre > Run
545: pay_action_interlocks pai_rev, --Run > Rev
546: pay_assignment_actions paa_rev, --Rev
547: pay_payroll_actions ppa_rev --Rev
548: where pai_run.locking_action_id = pai_pre.locked_action_id
549: and pai_rev.locked_action_id = pai_run.locked_action_id

Line 775: from pay_action_interlocks int2,

771: and popm.defined_balance_id IS NOT NULL)
772: -- and is not a reversal.
773: and not exists
774: ( select ''
775: from pay_action_interlocks int2,
776: pay_action_interlocks int3,
777: pay_assignment_actions paa4,
778: pay_payroll_actions ppa_run, --- RUN
779: pay_payroll_actions pact4, --- Reversal

Line 776: pay_action_interlocks int3,

772: -- and is not a reversal.
773: and not exists
774: ( select ''
775: from pay_action_interlocks int2,
776: pay_action_interlocks int3,
777: pay_assignment_actions paa4,
778: pay_payroll_actions ppa_run, --- RUN
779: pay_payroll_actions pact4, --- Reversal
780: pay_assignment_actions paa_run, --- RUN

Line 804: from pay_action_interlocks pai

800: ** assignment action for each pre-payment (bug 890222)
801: *****************************************************************/
802: cursor c_pre_payments (cp_nacha_action_id in number) is
803: select locked_action_id
804: from pay_action_interlocks pai
805: where pai.locking_action_id = cp_nacha_action_id;
806:
807: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
808: select assignment_action_id

Line 809: from pay_action_interlocks pai,

805: where pai.locking_action_id = cp_nacha_action_id;
806:
807: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
808: select assignment_action_id
809: from pay_action_interlocks pai,
810: pay_assignment_actions paa
811: where pai.locking_action_id = cp_pre_pymt_action_id
812: and paa.assignment_Action_id = pai.locked_action_id
813: and paa.run_type_id is null

Line 934: from pay_action_interlocks int2,

930: -- and is not a reversal.
931: and not exists
932: (
933: Select ''''
934: from pay_action_interlocks int2,
935: pay_action_interlocks int3,
936: pay_assignment_actions paa4,
937: pay_payroll_actions ppa_run, --- RUN
938: pay_payroll_actions pact4, --- Reversal

Line 935: pay_action_interlocks int3,

931: and not exists
932: (
933: Select ''''
934: from pay_action_interlocks int2,
935: pay_action_interlocks int3,
936: pay_assignment_actions paa4,
937: pay_payroll_actions ppa_run, --- RUN
938: pay_payroll_actions pact4, --- Reversal
939: pay_assignment_actions paa_run, --- RUN