APPS.OKC_COPY_CONTRACT_PVT dependencies on OKS_STREAM_LEVELS_B

Line 11846: FROM OKS_STREAM_LEVELS_B

11842: ,COMMENTS
11843: ,DUE_ARR_YN
11844: ,AMOUNT
11845: ,LINES_DETAILED_YN
11846: FROM OKS_STREAM_LEVELS_B
11847: WHERE CLE_ID = P_From_Cle_ID
11848: AND dnz_chr_id = P_FROM_CHR_ID
11849: ORDER BY SEQUENCE_NO;
11850:

Line 12273: FROM OKS_STREAM_LEVELS_B SLL

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);
12275:
12276: DELETE FROM OKS_STREAM_LEVELS_B
12277: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;

Line 12276: DELETE FROM OKS_STREAM_LEVELS_B

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);
12275:
12276: DELETE FROM OKS_STREAM_LEVELS_B
12277: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
12278:
12279: -- bug fix 4188236
12280:

Line 12397: FROM OKS_STREAM_LEVELS_B SLL

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);
12399:
12400: DELETE FROM OKS_STREAM_LEVELS_B
12401: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;

Line 12400: DELETE FROM OKS_STREAM_LEVELS_B

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);
12399:
12400: DELETE FROM OKS_STREAM_LEVELS_B
12401: WHERE DNZ_CHR_ID = P_CHR_ID and CLE_ID IS NULL;
12402:
12403: -- bug fix 4188236
12404: