APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_STD_ART_SET_MEMS

Line 1860: FROM OKC_STD_ART_SET_MEMS SM, OKC_FOLDERS_ALL_B FLD

1856: SM.CREATION_DATE,
1857: SM.LAST_UPDATED_BY,
1858: SM.LAST_UPDATE_LOGIN,
1859: SM.LAST_UPDATE_DATE
1860: FROM OKC_STD_ART_SET_MEMS SM, OKC_FOLDERS_ALL_B FLD
1861: WHERE FLD.SAT_CODE = SM.SAT_CODE
1862: AND SAE_ID = art_system_reference_id1_tbl(i)
1863: AND system_reference_code_tbl(i) = 'OKCMIGORIG'
1864: AND art_process_status_tbl(i) = 'S'

Line 1947: UPDATE OKC_STD_ART_SET_MEMS MEM

1943: END;
1944:
1945:
1946: /*
1947: UPDATE OKC_STD_ART_SET_MEMS MEM
1948: SET SAE_ID = article_id_tbl(i)
1949: WHERE SAE_ID = art_system_reference_id1_tbl(i)
1950: AND system_reference_code_tbl(i) = 'OKCMIGORIG'
1951: AND art_process_status_tbl(i) = 'S';