[Home] [Help]
301: select 1
302: from dual
303: where exists
304: (select 1
305: from pay_action_interlocks pai_mag,
306: pay_assignment_actions paa_mag,
307: pay_payroll_actions ppa_mag
308: where pai_mag.locked_action_id = cp_prepayment_action_id
309: and pai_mag.locking_Action_id = paa_mag.assignment_action_id
422: and popm.defined_balance_id IS NOT NULL)
423: -- and is not a reversal.
424: AND NOT EXISTS
425: ( Select ' '
426: from pay_action_interlocks int2,
427: pay_action_interlocks int4,
428: pay_assignment_actions paa4,
429: pay_payroll_actions ppa_run, --- RUN
430: pay_payroll_actions pact4, --- Reversal
423: -- and is not a reversal.
424: AND NOT EXISTS
425: ( Select ' '
426: from pay_action_interlocks int2,
427: pay_action_interlocks int4,
428: pay_assignment_actions paa4,
429: pay_payroll_actions ppa_run, --- RUN
430: pay_payroll_actions pact4, --- Reversal
431: pay_assignment_actions paa_run --- RUN
500: and pos.person_id between stperson and endperson
501: and (paf1.payroll_id = ppa_dar.payroll_id or ppa_dar.payroll_id is null)
502: and not exists
503: ( select ''
504: from pay_action_interlocks int2,
505: pay_action_interlocks int3,
506: pay_assignment_actions paa4,
507: pay_payroll_actions ppa_run, --- RUN
508: pay_payroll_actions pact4, --- Reversal
501: and (paf1.payroll_id = ppa_dar.payroll_id or ppa_dar.payroll_id is null)
502: and not exists
503: ( select ''
504: from pay_action_interlocks int2,
505: pay_action_interlocks int3,
506: pay_assignment_actions paa4,
507: pay_payroll_actions ppa_run, --- RUN
508: pay_payroll_actions pact4, --- Reversal
509: pay_assignment_actions paa_run, --- RUN
527: ** assignment action for each pre-payment.
528: *****************************************************************/
529: cursor c_pre_payments (cp_dd_action_id in number) is
530: select locked_action_id
531: from pay_action_interlocks pai
532: where pai.locking_action_id = cp_dd_action_id; --Direct Deposit dd
533:
534: /*****************************************************************
535: ** This cursor will get all the source actions for which the
544: order by ppp.source_action_id;
545:
546: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
547: select assignment_action_id
548: from pay_action_interlocks pai,
549: pay_assignment_actions paa
550: where pai.locking_action_id = cp_pre_pymt_action_id
551: and paa.assignment_Action_id = pai.locked_action_id
552: and paa.run_type_id is null
649: )
650: and not exists
651: (
652: Select ''''
653: from pay_action_interlocks int2,
654: pay_action_interlocks int3,
655: pay_assignment_actions paa4,
656: pay_payroll_actions ppa_run, --- RUN
657: pay_payroll_actions pact4, --- Reversal
650: and not exists
651: (
652: Select ''''
653: from pay_action_interlocks int2,
654: pay_action_interlocks int3,
655: pay_assignment_actions paa4,
656: pay_payroll_actions ppa_run, --- RUN
657: pay_payroll_actions pact4, --- Reversal
658: pay_assignment_actions paa_run, --- RUN
891: paa_pyarch.tax_unit_id
892: from pay_payroll_actions ppa_pyarch,
893: pay_assignment_actions paa_pyarch,
894: per_assignments_f paf,
895: pay_action_interlocks pai_pre
896: where ppa_pyarch.report_type = 'PY_ARCHIVER'
897: and ppa_pyarch.report_category = 'RT'
898: and ppa_pyarch.report_qualifier = 'PYCAPYAR'
899: and cp_deposit_end_date between ppa_pyarch.start_date
929: cp_deposit_end_date,
930: cp_consolidation_set_id) = 'Y'
931: and not exists
932: (Select 1
933: from pay_action_interlocks pai_run, --Pre > Run
934: pay_action_interlocks pai_rev, --Run > Rev
935: pay_assignment_actions paa_rev, --Rev
936: pay_payroll_actions ppa_rev --Rev
937: where pai_run.locking_action_id = pai_pre.locked_action_id
930: cp_consolidation_set_id) = 'Y'
931: and not exists
932: (Select 1
933: from pay_action_interlocks pai_run, --Pre > Run
934: pay_action_interlocks pai_rev, --Run > Rev
935: pay_assignment_actions paa_rev, --Rev
936: pay_payroll_actions ppa_rev --Rev
937: where pai_run.locking_action_id = pai_pre.locked_action_id
938: and pai_rev.locked_action_id = pai_run.locked_action_id