APPS.CSE_DEPLOYMENT_GRP dependencies on CSI_I_ASSETS

Line 39: FROM csi_i_assets

35: instance_id,
36: fa_asset_id,
37: fa_book_type_code,
38: fa_location_id
39: FROM csi_i_assets
40: WHERE instance_id = p_instance_id
41: AND fa_asset_id = p_asset_id
42: AND asset_quantity > 0
43: AND sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1);