[Home] [Help]
63: , aatd.checkrun_id
64: , TC.description --Bug5502917
65: FROM ap_awt_temp_distributions_all AATD,
66: ap_invoices_all AI,
67: ap_tax_codes_all TC
68: WHERE AATD.invoice_id = InvId
69: AND AATD.invoice_id = AI.invoice_id
70: AND AATD.tax_name = TC.name(+)
71: AND TC.org_id = AI.org_id -- Bug5902006
775: --, APID.ussgl_transaction_code ussgl_transaction_code - Bug 4277744
776: --, APID.ussgl_trx_code_context ussgl_trx_code_context - Bug 4277744
777: , APID.org_id
778: FROM ap_invoice_distributions_all APID,
779: ap_tax_codes_all ATC,
780: ap_invoices_all AI
781: WHERE (APID.invoice_id = InvId)
782: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,invoice_line_number))
783: AND (APID.distribution_line_number = NVL(P_dist_Line_No,distribution_line_number))
866: s.pay_group_lookup_code,
867: s.accts_pay_code_combination_id,
868: s.party_site_id,
869: pv.party_id
870: FROM ap_tax_codes_all t,
871: ap_system_parameters_all p,
872: po_vendor_sites_all s,
873: po_vendors pv
874: WHERE t.tax_id = TaxId
2558: , TC.tax_id tax_code_id
2559: , aatd.checkrun_id
2560: FROM ap_awt_temp_distributions_all AATD,
2561: ap_invoices_all AI,
2562: ap_tax_codes_all TC
2563: WHERE AATD.invoice_id = InvId
2564: AND AATD.invoice_id = AI.invoice_id
2565: AND TC.name(+) = AATD.tax_name
2566: AND TC.tax_type = 'AWT' -- BUG 3665866
2587: ret BOOLEAN;
2588:
2589: CURSOR c_get_limit IS
2590: SELECT 'Limit ExISts'
2591: FROM ap_tax_codes_all
2592: WHERE tax_id = TaxId
2593: AND awt_period_type IS not NULL;
2594:
2595: dummy CHAR(12);
2643: DECLARE
2644: CURSOR c_get_awt_period IS
2645: SELECT p.period_name
2646: FROM ap_other_periods P,
2647: ap_tax_codes_all C
2648: WHERE (rec_temp.accounting_date BETWEEN
2649: p.start_date AND p.end_date)
2650: AND p.period_type = c.awt_period_type
2651: AND c.name = rec_temp.tax_name