DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_TAX_CODES_ALL

Line 348: select name from ap_tax_codes_all

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
351: Cursor C_inv_cis_tax is
352: Select nvl(sum(amount),0) awt_amount

Line 361: select name from ap_tax_codes_all

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;
364: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
365: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;