APPS.JE_ITWHYE_AP_PKG dependencies on AP_AWT_TAX_RATES_ALL

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);