DBA Data[Home] [Help]

APPS.OKC_K_ART_VARIABLES_PVT dependencies on OKC_K_ART_VARIABLES_H

Line 2227: INSERT INTO OKC_K_ART_VARIABLES_H (

2223:
2224: -----------------------------------------
2225: -- Saving Base Table
2226: -----------------------------------------
2227: INSERT INTO OKC_K_ART_VARIABLES_H (
2228: major_version,
2229: CAT_ID,
2230: VARIABLE_CODE,
2231: VARIABLE_TYPE,

Line 2355: FROM OKC_K_ART_VARIABLES_H

2351: CREATION_DATE,
2352: LAST_UPDATED_BY,
2353: LAST_UPDATE_LOGIN,
2354: LAST_UPDATE_DATE
2355: FROM OKC_K_ART_VARIABLES_H
2356: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2357: WHERE DOCUMENT_TYPE = P_DOC_TYPE
2358: AND DOCUMENT_ID = P_DOC_ID)
2359: AND major_version = p_major_version;

Line 2416: FROM OKC_K_ART_VARIABLES_H

2412: -----------------------------------------
2413: -- Restoring Base Table
2414: -----------------------------------------
2415: DELETE
2416: FROM OKC_K_ART_VARIABLES_H
2417: WHERE cat_id in (SELECT ID FROM OKC_K_ARTICLES_BH
2418: WHERE document_type = p_doc_type and document_id = p_doc_id)
2419: AND major_version = p_major_version;
2420: