54: CURSOR l_get_instlocid(cp_fin_asset_id IN NUMBER) IS
55: SELECT csi.install_location_id,
56: -- csi.location_id
57: csi.install_location_type_code
58: FROM csi_item_instances csi,
59: okc_k_items cim,
60: okc_k_lines_b inst,
61: okc_k_lines_b ib,
62: okc_line_styles_b lse