APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 313: from pay_action_interlocks pai_mag,

309: select 1
310: from dual
311: where exists
312: (select 1
313: from pay_action_interlocks pai_mag,
314: pay_assignment_actions paa_mag,
315: pay_payroll_actions ppa_mag,
316: pay_org_payment_methods_f popm,
317: pay_pre_payments ppp,

Line 397: from pay_action_interlocks paci,

393: ** we get it from interlocks.
394: ****************************************************************/
395: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
396: select paa.assignment_action_id
397: from pay_action_interlocks paci,
398: pay_assignment_actions paa,
399: pay_payroll_actions ppa
400: where paci.locking_action_id = cp_assignment_action_id
401: and paa.assignment_action_id = paci.locked_action_id

Line 414: from pay_action_interlocks pai_run,

410: ** means there is a seperate check.
411: * ***************************************************************/
412: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
413: select paa_pre.assignment_action_id
414: from pay_action_interlocks pai_run,
415: pay_action_interlocks pai_pre,
416: pay_assignment_actions paa_pre,
417: pay_payroll_actions ppa_pre
418: where pai_run.locking_action_id = cp_assignment_action_id

Line 415: pay_action_interlocks pai_pre,

411: * ***************************************************************/
412: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
413: select paa_pre.assignment_action_id
414: from pay_action_interlocks pai_run,
415: pay_action_interlocks pai_pre,
416: pay_assignment_actions paa_pre,
417: pay_payroll_actions ppa_pre
418: where pai_run.locking_action_id = cp_assignment_action_id
419: and pai_pre.locked_action_id = pai_run.locked_action_id

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

463: INTO lv_rev_run_exists
464: FROM dual
465: where exists
466: (Select /*+ ORDERED */ 1
467: from pay_action_interlocks pai_run, --Pre > Run
468: pay_action_interlocks pai_rev, --Run > Rev
469: pay_assignment_actions paa_rev, --Rev
470: pay_payroll_actions ppa_rev --Rev
471: where pai_run.locking_action_id = ln_prepay_action_id

Line 468: pay_action_interlocks pai_rev, --Run > Rev

464: FROM dual
465: where exists
466: (Select /*+ ORDERED */ 1
467: from pay_action_interlocks pai_run, --Pre > Run
468: pay_action_interlocks pai_rev, --Run > Rev
469: pay_assignment_actions paa_rev, --Rev
470: pay_payroll_actions ppa_rev --Rev
471: where pai_run.locking_action_id = ln_prepay_action_id
472: and pai_rev.locked_action_id = pai_run.locked_action_id

Line 518: pay_action_interlocks pai_pre

514: paa_xfr.tax_unit_id
515: from
516: pay_payroll_actions ppa_xfr,
517: pay_assignment_actions paa_xfr,
518: pay_action_interlocks pai_pre
519: where ppa_xfr.report_type = 'XFR_INTERFACE'
520: and ppa_xfr.report_category = 'RT'
521: and ppa_xfr.report_qualifier = 'FED'
522: /* Bug : 7558310

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

547: cp_deposit_end_date,
548: cp_consolidation_set_id) = 'Y' --Bug 3512116
549: and not exists
550: (Select /*+ ORDERED */ 1
551: from pay_action_interlocks pai_run, --Pre > Run
552: pay_action_interlocks pai_rev, --Run > Rev
553: pay_assignment_actions paa_rev, --Rev
554: pay_payroll_actions ppa_rev --Rev
555: where pai_run.locking_action_id = pai_pre.locked_action_id

Line 552: pay_action_interlocks pai_rev, --Run > Rev

548: cp_consolidation_set_id) = 'Y' --Bug 3512116
549: and not exists
550: (Select /*+ ORDERED */ 1
551: from pay_action_interlocks pai_run, --Pre > Run
552: pay_action_interlocks pai_rev, --Run > Rev
553: pay_assignment_actions paa_rev, --Rev
554: pay_payroll_actions ppa_rev --Rev
555: where pai_run.locking_action_id = pai_pre.locked_action_id
556: and pai_rev.locked_action_id = pai_run.locked_action_id

Line 785: from pay_action_interlocks int2,

781: and popm.defined_balance_id IS NOT NULL)
782: -- and is not a reversal.
783: and not exists
784: ( select ''
785: from pay_action_interlocks int2,
786: pay_action_interlocks int3,
787: pay_assignment_actions paa4,
788: pay_payroll_actions ppa_run, --- RUN
789: pay_payroll_actions pact4, --- Reversal

Line 786: pay_action_interlocks int3,

782: -- and is not a reversal.
783: and not exists
784: ( select ''
785: from pay_action_interlocks int2,
786: pay_action_interlocks int3,
787: pay_assignment_actions paa4,
788: pay_payroll_actions ppa_run, --- RUN
789: pay_payroll_actions pact4, --- Reversal
790: pay_assignment_actions paa_run, --- RUN

Line 814: from pay_action_interlocks pai

810: ** assignment action for each pre-payment (bug 890222)
811: *****************************************************************/
812: cursor c_pre_payments (cp_nacha_action_id in number) is
813: select locked_action_id
814: from pay_action_interlocks pai
815: where pai.locking_action_id = cp_nacha_action_id;
816:
817: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
818: select assignment_action_id

Line 819: from pay_action_interlocks pai,

815: where pai.locking_action_id = cp_nacha_action_id;
816:
817: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
818: select assignment_action_id
819: from pay_action_interlocks pai,
820: pay_assignment_actions paa
821: where pai.locking_action_id = cp_pre_pymt_action_id
822: and paa.assignment_Action_id = pai.locked_action_id
823: and paa.run_type_id is null

Line 944: from pay_action_interlocks int2,

940: -- and is not a reversal.
941: and not exists
942: (
943: Select ''''
944: from pay_action_interlocks int2,
945: pay_action_interlocks int3,
946: pay_assignment_actions paa4,
947: pay_payroll_actions ppa_run, --- RUN
948: pay_payroll_actions pact4, --- Reversal

Line 945: pay_action_interlocks int3,

941: and not exists
942: (
943: Select ''''
944: from pay_action_interlocks int2,
945: pay_action_interlocks int3,
946: pay_assignment_actions paa4,
947: pay_payroll_actions ppa_run, --- RUN
948: pay_payroll_actions pact4, --- Reversal
949: pay_assignment_actions paa_run, --- RUN