APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_K_ARTICLES_TL

Line 1769: (SELECT TL.ID FROM OKC_K_ARTICLES_TL TL

1765: SET ARTICLE_VERSION_ID = t_article_version_id_tbl(i),
1766: SAV_SAE_ID = t_article_id_tbl(i),
1767: ORIG_ARTICLE_ID = t_article_id_tbl(i)
1768: WHERE OLD_ID IN
1769: (SELECT TL.ID FROM OKC_K_ARTICLES_TL TL
1770: WHERE sav_sav_release=t_artv_sav_release_tbl(i)
1771: AND language=l_language
1772: AND text is NULL )
1773: AND sav_sae_id = t_ver_system_reference_id1_tbl(i)

Line 1807: (SELECT TL.ID, TL.MAJOR_VERSION FROM OKC_K_ARTICLES_TLH TL

1803: SET ARTICLE_VERSION_ID = t_article_version_id_tbl(i),
1804: SAV_SAE_ID = t_article_id_tbl(i),
1805: ORIG_ARTICLE_ID = t_article_id_tbl(i)
1806: WHERE (OLD_ID, MAJOR_VERSION) IN
1807: (SELECT TL.ID, TL.MAJOR_VERSION FROM OKC_K_ARTICLES_TLH TL
1808: WHERE sav_sav_release=t_artv_sav_release_tbl(i)
1809: AND TL.ID = B.OLD_ID
1810: AND TL.MAJOR_VERSION = B.MAJOR_VERSION
1811: AND language=l_language