DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_AWT_TAX_RATES_ALL

Line 346: from ap_awt_tax_rates_all

342: and invoice_id = p_inv_id
343: and awt_invoice_payment_id = p_inv_pay_id
344: and awt_tax_rate_id in (
345: select tax_rate_id
346: from ap_awt_tax_rates_all
347: where tax_name in (
348: select name from ap_tax_codes_all
349: where awt_vendor_id = fnd_profile.value('IGI_CIS2007_TAX_AUTHORITY')));
350: --when the WHT is applied at the invoice validation level

Line 359: from ap_awt_tax_rates_all

355: and invoice_id = p_inv_id
356: and awt_invoice_payment_id is null
357: and awt_tax_rate_id in (
358: select tax_rate_id
359: from ap_awt_tax_rates_all
360: where tax_name in (
361: select name from ap_tax_codes_all
362: where awt_vendor_id = fnd_profile.value('IGI_CIS2007_TAX_AUTHORITY')));
363: l_inv_amount number;