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:
747: --sechawla 24-nov-09 9001258 : commented out the cursor
748: /*
749: CURSOR l_contract_outst_bal_csr (

Line 755: , OKC_K_HEADERS_B CHR

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

Line 771: , OKC_K_HEADERS_B CHR

767: SELECT l.contract_line_id contract_line_id,
768: l.stream_type_id stream_type_id,
769: SUM (l.amount_due_remaining) amount_due
770: FROM okl_bpd_ar_inv_lines_v l
771: , OKC_K_HEADERS_B CHR
772: ,okc_k_lines_b cle,
773: okc_statuses_b sts
774: WHERE l.contract_id = cp_chr_id
775: and l.contract_line_id = cle.id

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

815: AND l.contract_line_id = cp_cle_id
816: AND NVL (l.amount_due_remaining, 0) <> 0
817: GROUP BY l.contract_line_id,l.stream_type_id;
818: */
819: --modified as part of bug 7303686 to include OKC_K_HEADERS_B
820: CURSOR l_line_outst_bal_csr (
821: cp_chr_id NUMBER,
822: cp_cle_id NUMBER) IS
823: SELECT l.contract_line_id contract_line_id,

Line 827: , OKC_K_HEADERS_B CHR

823: SELECT l.contract_line_id contract_line_id,
824: l.stream_type_id stream_type_id,
825: SUM (l.amount_due_remaining) amount_due
826: FROM okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
827: , OKC_K_HEADERS_B CHR
828: WHERE l.contract_id = cp_chr_id
829: AND l.contract_line_id = cp_cle_id
830: AND NVL (l.amount_due_remaining, 0) <> 0
831: AND CHR.ID = l.contract_id

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

849: AND l.contract_line_id = i.cle_id
850: AND NVL (l.amount_due_remaining, 0) <> 0
851: GROUP BY l.contract_line_id,l.stream_type_id;
852: */
853: --modified as part of bug 7303686 to include OKC_K_HEADERS_B
854: CURSOR l_subline_outst_bal_csr (
855: cp_chr_id NUMBER,
856: cp_cle_id NUMBER) IS
857: SELECT l.contract_line_id contract_line_id,

Line 862: , OKC_K_HEADERS_B CHR

858: l.stream_type_id stream_type_id,
859: SUM (l.amount_due_remaining) amount_due
860: FROM okc_k_items i,
861: okl_bpd_ar_inv_lines_v l --ansethur 01-MAR-2007 Added for R12 B Billing Architecture
862: , OKC_K_HEADERS_B CHR
863: WHERE i.object1_id1 = cp_cle_id
864: AND l.contract_id = cp_chr_id
865: AND l.contract_line_id = i.cle_id
866: AND NVL (l.amount_due_remaining, 0) <> 0