DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKS_LEVEL_ELEMENTS

Line 12270: DELETE FROM OKS_LEVEL_ELEMENTS

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

Line 12394: DELETE FROM OKS_LEVEL_ELEMENTS

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