DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_STD_ART_VERSIONS_V

Line 1700: FROM okc_std_art_versions_v

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

Line 1703: FROM okc_std_art_versions_v

1699: SELECT sav_release
1700: FROM okc_std_art_versions_v
1701: WHERE sae_id = p_sae_id
1702: AND creation_date = (SELECT max(creation_date)
1703: FROM okc_std_art_versions_v
1704: WHERE sae_id = p_sae_id)
1705: AND date_active <= sysdate;
1706:
1707: BEGIN