APPS.OKL_BILLING_UTIL_PVT dependencies on OKL_CNSLD_AR_HDRS_B

Line 971: -- corresponding records exist in okl_cnsld_ar_hdrs_b, okl_cnsld_ar_lines_b,

967: AND OKL_XTL_SELL_INVS_B.TIL_ID IS NOT NULL);
968:
969: -- This cursor is used for the following purpose
970: -- For every record in okl_ext_sell_invs_b, okl_xtl_sell_invs_b check if
971: -- corresponding records exist in okl_cnsld_ar_hdrs_b, okl_cnsld_ar_lines_b,
972: -- okl_cnsld_ar_Strms_b tables.
973:
974: CURSOR ext_cnsld_check_csr IS
975: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER

Line 998: , OKL_CNSLD_AR_HDRS_B

994: CURSOR cnsld_ar_check_csr IS
995: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
996: FROM OKL_CNSLD_AR_STRMS_B
997: , OKL_CNSLD_AR_LINES_B
998: , OKL_CNSLD_AR_HDRS_B
999: , OKL_K_HEADERS
1000: , OKC_K_HEADERS_B
1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID

Line 1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID

997: , OKL_CNSLD_AR_LINES_B
998: , OKL_CNSLD_AR_HDRS_B
999: , OKL_K_HEADERS
1000: , OKC_K_HEADERS_B
1001: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1002: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1003: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1004: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1005: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID

Line 1014: , OKL_CNSLD_AR_HDRS_B

1010: CURSOR cnsld_pstv_check_csr IS
1011: SELECT DISTINCT OKC_K_HEADERS_B.CONTRACT_NUMBER
1012: FROM OKL_CNSLD_AR_STRMS_B
1013: , OKL_CNSLD_AR_LINES_B
1014: , OKL_CNSLD_AR_HDRS_B
1015: , OKL_K_HEADERS
1016: , OKC_K_HEADERS_B
1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID

Line 1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID

1013: , OKL_CNSLD_AR_LINES_B
1014: , OKL_CNSLD_AR_HDRS_B
1015: , OKL_K_HEADERS
1016: , OKC_K_HEADERS_B
1017: WHERE OKL_CNSLD_AR_LINES_B.CNR_ID = OKL_CNSLD_AR_HDRS_B.ID
1018: AND OKL_CNSLD_AR_STRMS_B.LLN_ID = OKL_CNSLD_AR_LINES_B.ID
1019: AND OKC_K_HEADERS_B.ID = OKL_K_HEADERS.ID
1020: AND OKL_K_HEADERS.ID = OKL_CNSLD_AR_STRMS_B.KHR_ID
1021: AND OKL_CNSLD_AR_STRMS_B.KHR_ID = OKL_CNSLD_AR_LINES_B.KHR_ID