APPS.OKC_COPY_CONTRACT_PVT dependencies on OKS_STREAM_LEVELS_B

Line 11847: FROM OKS_STREAM_LEVELS_B

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:

Line 12274: FROM OKS_STREAM_LEVELS_B SLL

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;

Line 12277: DELETE FROM OKS_STREAM_LEVELS_B

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:

Line 12398: FROM OKS_STREAM_LEVELS_B SLL

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;

Line 12401: DELETE FROM OKS_STREAM_LEVELS_B

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: