APPS.JE_ITWHYE_AP_PKG dependencies on AP_TAX_CODES_ALL

Line 463: FROM ap_tax_codes_all atc_sub,

459: WHERE dist.invoice_id = cur_withholding_extract_rec.invoice_id
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

Line 511: FROM ap_tax_codes_all atc_sub,

507: AND dist.invoice_id = cur_withholding_extract_rec.invoice_id
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