APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_I_ASSETS

Line 5994: SELECT '1' FROM csi_i_assets

5990: BEGIN
5991: SELECT 'Y' INTO l_cia_found
5992: FROM sys.dual
5993: WHERE exists (
5994: SELECT '1' FROM csi_i_assets
5995: WHERE instance_id = l_upd_instance_rec.instance_id
5996: AND sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1));
5997: l_upd_instance_rec.operational_status_code := 'IN_SERVICE';
5998: EXCEPTION