APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_I_ASSETS

Line 6254: SELECT '1' FROM csi_i_assets

6250: BEGIN
6251: SELECT 'Y' INTO l_cia_found
6252: FROM sys.dual
6253: WHERE exists (
6254: SELECT '1' FROM csi_i_assets
6255: WHERE instance_id = l_upd_instance_rec.instance_id
6256: AND sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1));
6257: l_upd_instance_rec.operational_status_code := 'IN_SERVICE';
6258: EXCEPTION