APPS.OKL_AM_CALC_QUOTE_STREAM_PVT dependencies on OKC_K_HEADERS_B

Line 574: FROM OKC_K_HEADERS_B chr

570:
571: -- rmunjulu bug 5005225
572: CURSOR get_k_sts_csr (p_khr_id IN NUMBER) IS
573: SELECT chr.sts_code
574: FROM OKC_K_HEADERS_B chr
575: WHERE chr.id = p_khr_id;
576:
577: -- rmunjulu bug 5005225
578: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;

Line 578: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;

574: FROM OKC_K_HEADERS_B chr
575: WHERE chr.id = p_khr_id;
576:
577: -- rmunjulu bug 5005225
578: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;
579:
580: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'process_unbilled_receivables';
581: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
582: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 745: --modified as part of bug 7303686 to include OKC_K_HEADERS_B

741: WHERE l.CONTRACT_ID = cp_chr_id
742: AND NVL (l.amount_due_remaining, 0) <> 0
743: GROUP BY l.contract_line_id,
744: l.stream_type_id; */
745: --modified as part of bug 7303686 to include OKC_K_HEADERS_B
746: CURSOR l_contract_outst_bal_csr (
747: cp_chr_id NUMBER) IS
748: SELECT l.contract_line_id contract_line_id,
749: l.stream_type_id stream_type_id,

Line 752: , OKC_K_HEADERS_B CHR

748: SELECT l.contract_line_id contract_line_id,
749: l.stream_type_id stream_type_id,
750: SUM (l.amount_due_remaining) amount_due
751: FROM okl_bpd_ar_inv_lines_v l
752: , OKC_K_HEADERS_B CHR
753: WHERE l.contract_id = cp_chr_id
754: AND NVL (l.amount_due_remaining, 0) <> 0
755: AND CHR.ID = l.contract_id
756: AND CHR.CUST_ACCT_ID = l.IXX_ID

Line 772: --modified as part of bug 7303686 to include OKC_K_HEADERS_B

768: AND l.contract_line_id = cp_cle_id
769: AND NVL (l.amount_due_remaining, 0) <> 0
770: GROUP BY l.contract_line_id,l.stream_type_id;
771: */
772: --modified as part of bug 7303686 to include OKC_K_HEADERS_B
773: CURSOR l_line_outst_bal_csr (
774: cp_chr_id NUMBER,
775: cp_cle_id NUMBER) IS
776: SELECT l.contract_line_id contract_line_id,

Line 780: , OKC_K_HEADERS_B CHR

776: SELECT l.contract_line_id contract_line_id,
777: l.stream_type_id stream_type_id,
778: SUM (l.amount_due_remaining) amount_due
779: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
780: , OKC_K_HEADERS_B CHR
781: WHERE l.contract_id = cp_chr_id
782: AND l.contract_line_id = cp_cle_id
783: AND NVL (l.amount_due_remaining, 0) <> 0
784: AND CHR.ID = l.contract_id

Line 804: --modified as part of bug 7303686 to include OKC_K_HEADERS_B

800: AND l.contract_line_id = i.cle_id
801: AND NVL (l.amount_due_remaining, 0) <> 0
802: GROUP BY l.contract_line_id,l.stream_type_id;
803: */
804: --modified as part of bug 7303686 to include OKC_K_HEADERS_B
805: CURSOR l_subline_outst_bal_csr (
806: cp_chr_id NUMBER,
807: cp_cle_id NUMBER) IS
808: SELECT l.contract_line_id contract_line_id,

Line 813: , OKC_K_HEADERS_B CHR

809: l.stream_type_id stream_type_id,
810: SUM (l.amount_due_remaining) amount_due
811: FROM okc_k_items i,
812: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
813: , OKC_K_HEADERS_B CHR
814: WHERE i.object1_id1 = cp_cle_id
815: AND l.contract_id = cp_chr_id
816: AND l.contract_line_id = i.cle_id
817: AND NVL (l.amount_due_remaining, 0) <> 0