1695: WHERE id = p_cat_id;
1696:
1697: CURSOR c_latest_version(p_sae_id IN NUMBER) IS
1698: SELECT sav_release
1699: FROM okc_std_art_versions_v
1700: WHERE sae_id = p_sae_id
1701: AND creation_date = (SELECT max(creation_date)
1702: FROM okc_std_art_versions_v
1703: WHERE sae_id = p_sae_id)
1698: SELECT sav_release
1699: FROM okc_std_art_versions_v
1700: WHERE sae_id = p_sae_id
1701: AND creation_date = (SELECT max(creation_date)
1702: FROM okc_std_art_versions_v
1703: WHERE sae_id = p_sae_id)
1704: AND date_active <= sysdate;
1705:
1706: BEGIN