[Home] [Help]
2234: FROM po_vendor_sites
2235: WHERE vendor_id = x_vendor_id
2236: AND country = 'US'
2237: AND nvl(state,'99') not in (SELECT region_short_name
2238: FROM AP_income_tax_regions);
2239: if (L_Return_count > 0 ) then
2240: fnd_message.set_name('SQLAP','AP_VEN_WARN_INV_STATE');
2241: app_exception.raise_exception;
2242: end if;