1158: ,MINOR_VERSION
1159: ,MAJOR_VERSION -- comes here instead of OBJECT_VERSION_NUMBER
1160: ,CREATED_BY
1161: ,CREATION_DATE
1162: ,FND_GLOBAL.USER_ID
1163: ,sysdate
1164: ,FND_GLOBAL.LOGIN_ID
1165: from okc_k_vers_numbers
1166: where chr_id = p_chr_id;
1160: ,CREATED_BY
1161: ,CREATION_DATE
1162: ,FND_GLOBAL.USER_ID
1163: ,sysdate
1164: ,FND_GLOBAL.LOGIN_ID
1165: from okc_k_vers_numbers
1166: where chr_id = p_chr_id;
1167:
1168: END IF;
2268: ,MINOR_VERSION
2269: ,0
2270: ,CREATED_BY
2271: ,CREATION_DATE
2272: ,FND_GLOBAL.USER_ID
2273: ,sysdate
2274: ,FND_GLOBAL.LOGIN_ID
2275: from okc_k_vers_numbers_h
2276: where chr_id = p_chr_id
2270: ,CREATED_BY
2271: ,CREATION_DATE
2272: ,FND_GLOBAL.USER_ID
2273: ,sysdate
2274: ,FND_GLOBAL.LOGIN_ID
2275: from okc_k_vers_numbers_h
2276: where chr_id = p_chr_id
2277: and MAJOR_VERSION = -1;
2278: --