APPS.JE_ITWHYE_AP_PKG dependencies on AP_AWT_GROUP_TAXES_ALL

Line 367: FROM ap_awt_group_taxes_all awt

363:
364: CURSOR cur_withholding_invoice(p_invoice_id NUMBER)
365: IS
366: SELECT count(1)rec_count
367: FROM ap_awt_group_taxes_all awt
368: WHERE awt.GROUP_ID IN (
369: SELECT DISTINCT dist.awt_origin_group_id
370: FROM ap_invoice_distributions_all dist,
371: ap_invoices_all inv

Line 465: ap_awt_group_taxes_all awgt_sub

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

Line 503: , ap_awt_group_taxes_all awt

499:
500: SELECT SUM (NVL (dist.base_amount, dist.amount))
501: INTO ln_tax_amount_two
502: FROM ap_invoice_distributions_all dist
503: , ap_awt_group_taxes_all awt
504: WHERE dist.invoice_id = invoice_id
505: AND NVL(dist.pay_awt_group_id,nvl(dist.awt_group_id, dist.awt_origin_group_id)) = awt.group_id --bug14369763
506: AND dist.org_id = awt.org_id
507: AND dist.invoice_id = cur_withholding_extract_rec.invoice_id

Line 513: ap_awt_group_taxes_all awgt_sub

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

Line 620: FROM ap_awt_group_taxes_all awt

616:
617: BEGIN
618: SELECT awt.group_id
619: into ln_awt_group_id
620: FROM ap_awt_group_taxes_all awt
621: WHERE awt.GROUP_ID IN (
622: SELECT DISTINCT dist.awt_origin_group_id
623: FROM ap_invoice_distributions_all dist,
624: ap_invoices_all inv