DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INCOME_TAX_REGIONS

Line 20631: l_income_tax_region ap_income_tax_regions.region_short_name%TYPE;

20627: l_values1 fnd_plsql_cache.generic_cache_values_type;
20628: l_ret_code1 VARCHAR2(1);
20629: l_exception1 VARCHAR2(10);
20630: l_income_tax_type ap_income_tax_types.income_tax_type%TYPE;
20631: l_income_tax_region ap_income_tax_regions.region_short_name%TYPE;
20632:
20633: -- Bug 9189995
20634: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
20635:

Line 20953: FROM ap_income_tax_regions

20949:
20950: BEGIN
20951: SELECT region_short_name
20952: INTO l_income_tax_region
20953: FROM ap_income_tax_regions
20954: WHERE region_short_name = p_invoice_lines_rec.income_tax_region
20955: AND AP_IMPORT_INVOICES_PKG.g_inv_sysdate
20956: BETWEEN NVL(active_date, AP_IMPORT_INVOICES_PKG.g_inv_sysdate) AND
20957: NVL(inactive_date, AP_IMPORT_INVOICES_PKG.g_inv_sysdate);