[Home] [Help]
280: -- and is not a reversal.
281: AND NOT EXISTS
282: (
283: Select ''
284: from pay_action_interlocks int2,
285: pay_action_interlocks int4,
286: pay_assignment_actions paa4,
287: pay_payroll_actions ppa_run, --- RUN
288: pay_payroll_actions pact4, --- Reversal
281: AND NOT EXISTS
282: (
283: Select ''
284: from pay_action_interlocks int2,
285: pay_action_interlocks int4,
286: pay_assignment_actions paa4,
287: pay_payroll_actions ppa_run, --- RUN
288: pay_payroll_actions pact4, --- Reversal
289: pay_assignment_actions paa_run --- RUN
307: ** assignment action for each pre-payment (bug 890222)
308: *****************************************************************/
309: cursor c_pre_payments (cp_nacha_action_id in number) is
310: select locked_action_id
311: from pay_action_interlocks pai
312: where pai.locking_action_id = cp_nacha_action_id;
313:
314: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
315: select assignment_action_id
312: where pai.locking_action_id = cp_nacha_action_id;
313:
314: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
315: select assignment_action_id
316: from pay_action_interlocks pai,
317: pay_assignment_actions paa
318: where pai.locking_action_id = cp_pre_pymt_action_id
319: and paa.assignment_Action_id = pai.locked_action_id
320: and paa.run_type_id is null
409: is null)
410: and not exists
411: (
412: Select ''''
413: from pay_action_interlocks int2,
414: pay_action_interlocks int3,
415: pay_assignment_actions paa4,
416: pay_payroll_actions ppa_run, --- RUN
417: pay_payroll_actions pact4, --- Reversal
410: and not exists
411: (
412: Select ''''
413: from pay_action_interlocks int2,
414: pay_action_interlocks int3,
415: pay_assignment_actions paa4,
416: pay_payroll_actions ppa_run, --- RUN
417: pay_payroll_actions pact4, --- Reversal
418: pay_assignment_actions paa_run, --- RUN
601: from per_assignments_f paf,
602: pay_payroll_actions ppa_dar,
603: pay_payroll_actions ppa_run,
604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,
606: pay_action_interlocks pai_run,
607: pay_assignment_actions paa_xfr,
608: pay_payroll_actions ppa_xfr
609: , pay_payrolls_f pay -- #2264358
602: pay_payroll_actions ppa_dar,
603: pay_payroll_actions ppa_run,
604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,
606: pay_action_interlocks pai_run,
607: pay_assignment_actions paa_xfr,
608: pay_payroll_actions ppa_xfr
609: , pay_payrolls_f pay -- #2264358
610: where ppa_dar.payroll_action_id = pactid
635: (select min(paa.assignment_action_id)
636: from pay_assignment_actions paa
637: where paa.assignment_action_id in (
638: select locked_action_id
639: from pay_action_interlocks
640: where locking_action_id = pai_run.locking_action_id)
641: and paa.source_action_id is null
642: )
643: )
659: and pay.payroll_id >= 0 --Bug 3343621
660: )
661: /* XFR => PRE */
662: and exists ( select 'Y'
663: from pay_action_interlocks pai_mag,
664: pay_assignment_actions paa_mag,
665: pay_payroll_actions ppa_mag
666: where pai_mag.locked_action_id = pai_pre.locked_action_id
667: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
686: and paf.person_id between stperson and endperson
687: and not exists
688: (
689: Select ''
690: from pay_action_interlocks int2,
691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal
687: and not exists
688: (
689: Select ''
690: from pay_action_interlocks int2,
691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal
695: pay_assignment_actions paa_run --- RUN
725: from per_assignments_f paf,
726: pay_payroll_actions ppa_dar,
727: pay_payroll_actions ppa_run,
728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,
732: pay_assignment_actions paa_pre,
733: pay_assignment_actions paa_run,
726: pay_payroll_actions ppa_dar,
727: pay_payroll_actions ppa_run,
728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,
730: pay_action_interlocks pai_run,
731: pay_assignment_actions paa_xfr,
732: pay_assignment_actions paa_pre,
733: pay_assignment_actions paa_run,
734: pay_payroll_actions ppa_xfr
765: paa_run.assignment_action_id =
766: (select min(paa.assignment_action_id)
767: from pay_assignment_actions paa
768: where paa.assignment_action_id in (select locked_action_id
769: from pay_action_interlocks
770: where locking_action_id = pai_run.locking_action_id)
771: and paa.source_action_id is null
772: )
773: )
794: and paf.person_id between stperson and endperson
795: and not exists
796: (
797: Select ''
798: from pay_action_interlocks int2,
799: pay_action_interlocks int3,
800: pay_assignment_actions paa4,
801: pay_payroll_actions ppa_run, --- RUN
802: pay_payroll_actions pact4, --- Reversal
795: and not exists
796: (
797: Select ''
798: from pay_action_interlocks int2,
799: pay_action_interlocks int3,
800: pay_assignment_actions paa4,
801: pay_payroll_actions ppa_run, --- RUN
802: pay_payroll_actions pact4, --- Reversal
803: pay_assignment_actions paa_run --- RUN