DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_INCOME_TAX_REGIONS

Line 18917: l_income_tax_region ap_income_tax_regions.region_short_name%TYPE;

18913: l_values1 fnd_plsql_cache.generic_cache_values_type;
18914: l_ret_code1 VARCHAR2(1);
18915: l_exception1 VARCHAR2(10);
18916: l_income_tax_type ap_income_tax_types.income_tax_type%TYPE;
18917: l_income_tax_region ap_income_tax_regions.region_short_name%TYPE;
18918:
18919: -- Bug 7599916
18920: Cursor c_type_1099(c_vendor_id NUMBER) Is
18921: Select pov.type_1099

Line 19186: FROM ap_income_tax_regions

19182:
19183: BEGIN
19184: SELECT region_short_name
19185: INTO l_income_tax_region
19186: FROM ap_income_tax_regions
19187: WHERE region_short_name = p_invoice_lines_rec.income_tax_region
19188: AND AP_IMPORT_INVOICES_PKG.g_inv_sysdate
19189: BETWEEN NVL(active_date, AP_IMPORT_INVOICES_PKG.g_inv_sysdate) AND
19190: NVL(inactive_date, AP_IMPORT_INVOICES_PKG.g_inv_sysdate);