[Home] [Help]
94: Fix for bug#2771166.
95: 30-JAN-2003 ssattini 115.17 Tuned the c_assignments cursor
96: to avoid full table scan on
97: pay_org_payment_method_f and
98: pay_pre_payments tables.
99: 03-FEB-2003 ssattini 115.18 2745577 Fixed the issue to print correct
100: Court Order/Case Number when
101: ran with multiple garnishment
102: elements for each assignment,
704: ,pay_payment_types_tl ppt_tl
705: ,pay_payment_types ppt
706: ,pay_org_payment_methods_f_tl popm_tl
707: ,pay_org_payment_methods_f popm
708: ,pay_pre_payments ppp
709: ,(select distinct paa_pre.assignment_action_id /* Locked Action Id */
710: --,paa_run.tax_unit_id -- commented for bug 7280782
711: ,paa_pre.tax_unit_id -- Added for bug 7280782
712: ,ppa_pre.date_earned
793: from
794: pay_payroll_actions ppa,
795: pay_assignment_actions paa,
796: pay_action_interlocks pai,
797: pay_pre_payments ppp
798: where pai.locked_action_id = cp_assignment_action_id
799: and pai.locking_action_id = paa.assignment_action_id
800: and paa.action_status = 'C'
801: and paa.pre_payment_id = cp_pre_payment_id
940: ,cp_pre_payment_id in number) is
941: select decode(ppa_pymt.action_type,
942: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
943: paa_pymt.serial_number)
944: from pay_pre_payments ppp,
945: pay_assignment_actions paa_pymt,
946: pay_payroll_actions ppa_pymt,
947: pay_action_interlocks pai
948: where pai.locked_action_id = cp_pre_payment_action