DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKS_LEVEL_ELEMENTS

Line 12271: DELETE FROM OKS_LEVEL_ELEMENTS

12267: RAISE G_EXCEPTION_HALT_VALIDATION;
12268: END IF;
12269:
12270: -- Delete Header billing schedule bug# 4188236
12271: DELETE FROM OKS_LEVEL_ELEMENTS
12272: WHERE RUL_ID IN
12273: (SELECT SLL.ID
12274: FROM OKS_STREAM_LEVELS_B SLL
12275: WHERE SLL.DNZ_CHR_ID=P_CHR_ID and CLE_ID IS NULL);

Line 12395: DELETE FROM OKS_LEVEL_ELEMENTS

12391: okc_debug.log('1070: Completed header update ' || l_return_status );
12392: END IF;
12393:
12394: -- Delete Header billing schedule bug# 4188236
12395: DELETE FROM OKS_LEVEL_ELEMENTS
12396: WHERE RUL_ID IN
12397: (SELECT SLL.ID
12398: FROM OKS_STREAM_LEVELS_B SLL
12399: WHERE SLL.DNZ_CHR_ID=P_CHR_ID and CLE_ID IS NULL);