11843: ,COMMENTS
11844: ,DUE_ARR_YN
11845: ,AMOUNT
11846: ,LINES_DETAILED_YN
11847: FROM OKS_STREAM_LEVELS_B
11848: WHERE CLE_ID = P_From_Cle_ID
11849: AND dnz_chr_id = P_FROM_CHR_ID
11850: ORDER BY SEQUENCE_NO;
11851:
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);
12276:
12277: DELETE FROM OKS_STREAM_LEVELS_B
12278: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
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);
12276:
12277: DELETE FROM OKS_STREAM_LEVELS_B
12278: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
12279:
12280: -- bug fix 4188236
12281:
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);
12400:
12401: DELETE FROM OKS_STREAM_LEVELS_B
12402: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
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);
12400:
12401: DELETE FROM OKS_STREAM_LEVELS_B
12402: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
12403:
12404: -- bug fix 4188236
12405: