DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_STD_ART_VERSIONS_V

Line 1699: FROM okc_std_art_versions_v

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)

Line 1702: FROM okc_std_art_versions_v

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