APPS.JE_ITWHYE_AP_PKG dependencies on AP_AWT_TAX_RATES

Line 464: ap_awt_tax_rates_all awt_sub,

460: AND dist.line_type_lookup_code in ('ITEM', 'ACCRUAL') --bug14369763
461: AND nvl(dist.pay_awt_group_id, nvl(dist.awt_group_id,dist.awt_origin_group_id)) IN ( --bug14369763
462: SELECT awgt_sub.GROUP_ID
463: FROM ap_tax_codes_all atc_sub,
464: ap_awt_tax_rates_all awt_sub,
465: ap_awt_group_taxes_all awgt_sub
466: WHERE awgt_sub.tax_name = awt_sub.tax_name
467: AND atc_sub.NAME = awt_sub.tax_name
468: AND awt_sub.tax_rate = 0);

Line 512: ap_awt_tax_rates_all awt_sub,

508: AND dist.line_type_lookup_code in ('ITEM','ACCRUAL') --bug14369763
509: AND NVL(dist.pay_awt_group_id, nvl(dist.awt_group_id, dist.awt_origin_group_id)) NOT IN ( --bug14369763
510: SELECT awgt_sub.GROUP_ID
511: FROM ap_tax_codes_all atc_sub,
512: ap_awt_tax_rates_all awt_sub,
513: ap_awt_group_taxes_all awgt_sub
514: WHERE awgt_sub.tax_name = awt_sub.tax_name
515: AND atc_sub.NAME = awt_sub.tax_name
516: AND awt_sub.tax_rate = 0);

Line 695: ap_awt_tax_rates awt,

691: lc_irpef_vendor_name
692: FROM ap_invoice_distributions dist,
693: ap_tax_codes atc,
694: ap_invoices inv1,
695: ap_awt_tax_rates awt,
696: ap_suppliers aps
697: WHERE dist.invoice_id = inv1.invoice_id
698: AND inv1.invoice_id = cur_withholding_extract_rec.invoice_id
699: AND dist.line_type_lookup_code = atc.tax_type

Line 747: ap_awt_tax_rates awt,

743: lc_inps_vendor_name
744: FROM ap_invoice_distributions dist,
745: ap_tax_codes atc,
746: ap_invoices inv1,
747: ap_awt_tax_rates awt,
748: ap_suppliers aps
749: WHERE dist.invoice_id = inv1.invoice_id
750: AND inv1.invoice_id = cur_withholding_extract_rec.invoice_id
751: AND dist.line_type_lookup_code = atc.tax_type