953: WHERE id = p_cat_id;
954:
955: CURSOR c_latest_version(p_sae_id IN NUMBER) IS
956: SELECT sav_release
957: FROM okc_std_art_versions_v
958: WHERE sae_id = p_sae_id
959: AND date_active = (SELECT max(date_active)
960: FROM okc_std_art_versions_v
961: WHERE sae_id = p_sae_id);
956: SELECT sav_release
957: FROM okc_std_art_versions_v
958: WHERE sae_id = p_sae_id
959: AND date_active = (SELECT max(date_active)
960: FROM okc_std_art_versions_v
961: WHERE sae_id = p_sae_id);
962:
963: l_sae_id NUMBER;
964: l_sav_release VARCHAR2(150);