DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 8820: FROM zx_input_classifications_v

8816: -- Checking the vat code in the tax tables
8817: l_status := 0;
8818: SELECT COUNT(*) INTO l_status FROM DUAL WHERE EXISTS (
8819: SELECT 'Y'
8820: FROM zx_input_classifications_v
8821: WHERE lookup_type in ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
8822: AND org_id in ( p_vendor_site_rec.org_id, -99)
8823: AND enabled_flag = 'Y'
8824: AND LOOKUP_CODE = p_vendor_site_rec.VAT_CODE );