APPS.AP_VENDOR_PUB_PKG dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 4912: FROM zx_input_classifications_v

4908: -- Checking the vat code in the tax tables
4909: l_status := 0;
4910: SELECT COUNT(*) INTO l_status FROM DUAL WHERE EXISTS (
4911: SELECT 'Y'
4912: FROM zx_input_classifications_v
4913: WHERE lookup_type in ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
4914: AND org_id = -99
4915: AND enabled_flag = 'Y'
4916: AND LOOKUP_CODE = p_vendor_rec.VAT_CODE );

Line 8743: FROM ZX_INPUT_CLASSIFICATIONS_V Zic

8739: IF l_tax_classification_code is not null THEN
8740: BEGIN
8741: SELECT Zic.Lookup_Code, Zic.End_Date_Active, zic.start_date_active
8742: INTO L_Zic_tax_classification_code, Zic_end_date_Active, Zic_start_date_active
8743: FROM ZX_INPUT_CLASSIFICATIONS_V Zic
8744: WHERE Zic.Lookup_Code = l_tax_classification_code
8745: AND ZIC.enabled_flag ='Y'
8746: AND ZIC.lookup_type='ZX_INPUT_CLASSIFICATIONS'
8747: AND Zic.Org_Id= L_Def_Org_Id;

Line 8752: l_debug_info := 'No data returned from ZX_INPUT_CLASSIFICATIONS_V for Lookup_Code = '||l_tax_classification_code

8748: EXCEPTION
8749: WHEN OTHERS THEN
8750: /* VAT_Code should not be defaulted if it of different OU than site*/
8751: l_tax_classification_code := null;
8752: l_debug_info := 'No data returned from ZX_INPUT_CLASSIFICATIONS_V for Lookup_Code = '||l_tax_classification_code
8753: || ' and org_id = '||L_Def_Org_Id;
8754: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8755: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
8756: END IF;

Line 10215: FROM zx_input_classifications_v

10211: -- Checking the vat code in the tax tables
10212: l_status := 0;
10213: SELECT COUNT(*) INTO l_status FROM DUAL WHERE EXISTS (
10214: SELECT 'Y'
10215: FROM zx_input_classifications_v
10216: WHERE lookup_type in ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
10217: AND org_id in ( p_vendor_site_rec.org_id, -99)
10218: AND enabled_flag = 'Y'
10219: AND LOOKUP_CODE = p_vendor_site_rec.VAT_CODE );