APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKC_K_HEADERS_B

Line 130: okc_k_headers_b khr

126: SELECT NVL(SUM(AMOUNT),0)- NVL(SUM(LINE_AMOUNT_REMAINING_WOTAX),0) interest_paid_amount
127: FROM okl_bpd_ar_inv_lines_v lpt1,
128: okl_strm_type_b sty,
129: ar_payment_schedules_all aps,
130: okc_k_headers_b khr
131: WHERE contract_id=cp_khr_id
132: AND lpt1.contract_id = khr.id
133: AND lpt1.sty_id = sty.id
134: AND (cp_kle_id IS NULL OR (cp_kle_id IS NOT NULL AND lpt1.contract_line_id = cp_kle_id))

Line 144: okc_k_headers_b khr

140: SELECT NVL(SUM(sel.amount),0) interest_paid_amount
141: FROM okl_strm_type_v sty,
142: okl_streams_v stm,
143: okl_strm_elements sel,
144: okc_k_headers_b khr
145: WHERE stm.khr_id = cp_khr_id
146: AND stm.kle_id = NVL(cp_kle_id, stm.kle_id)
147: AND stm.khr_id = khr.id
148: AND stm.sty_id = sty.id

Line 244: FROM OKC_K_HEADERS_B chr,

240: CURSOR l_contract_info_csr(cp_khr_id IN NUMBER) IS
241: SELECT chr.start_date,
242: chr.currency_code,
243: chr.end_date
244: FROM OKC_K_HEADERS_B chr,
245: OKL_K_HEADERS khr
246: WHERE chr.id = khr.id
247: AND khr.id = cp_khr_id;
248:

Line 478: FROM okc_k_headers_b chr,

474: l_stream_element_date DATE;
475:
476: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
477: SELECT chr.start_date, rpm.principal_basis_code
478: FROM okc_k_headers_b chr,
479: okl_k_headers khr,
480: okl_k_rate_params rpm
481: WHERE chr.id = khr.id
482: AND rpm.khr_id = khr.id

Line 716: okc_k_headers_b khr

712: SELECT SUM(AMOUNT)- SUM(LINE_AMOUNT_REMAINING_WOTAX) principal_paid_amount
713: FROM okl_bpd_ar_inv_lines_v lpt1,
714: okl_strm_type_b sty,
715: ar_payment_schedules_all aps,
716: okc_k_headers_b khr
717: WHERE contract_id=cp_khr_id
718: AND lpt1.contract_id = khr.id
719: AND lpt1.sty_id = sty.id
720: AND lpt1.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 730: okc_k_headers_b khr

726: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
727: FROM okl_strm_type_v sty,
728: okl_streams_v stm,
729: okl_strm_elements sel,
730: okc_k_headers_b khr
731: WHERE stm.khr_id = cp_khr_id
732: AND stm.kle_id = NVL(null, stm.kle_id)
733: AND stm.khr_id = khr.id
734: AND stm.sty_id = sty.id

Line 779: okc_k_headers_b khr

775: SELECT NVL(SUM(sel.amount),0) principal_paid_amount
776: FROM okl_strm_type_v sty,
777: okl_streams_v stm,
778: okl_strm_elements sel,
779: okc_k_headers_b khr
780: WHERE stm.khr_id = cp_khr_id
781: AND stm.kle_id = NVL(null, stm.kle_id)
782: AND stm.khr_id = khr.id
783: AND stm.sty_id = sty.id

Line 819: --okc_k_headers_b khr

815: --SELECT NVL(SUM(sel.amount),0) principal_paid_amount
816: --FROM okl_strm_type_v sty,
817: --okl_streams_v stm,
818: --okl_strm_elements sel,
819: --okc_k_headers_b khr
820: --WHERE stm.khr_id = cp_khr_id
821: --AND stm.kle_id = NVL(cp_kle_id, stm.kle_id)
822: --AND stm.khr_id = khr.id
823: --AND stm.sty_id = sty.id

Line 1100: FROM OKC_K_HEADERS_B chr,

1096: l_start_date DATE;
1097:
1098: CURSOR l_start_date_csr(cp_khr_id IN NUMBER) IS
1099: SELECT chr.start_date
1100: FROM OKC_K_HEADERS_B chr,
1101: OKL_K_HEADERS khr
1102: WHERE chr.id = khr.id
1103: AND khr.id = cp_khr_id;
1104: BEGIN

Line 1339: --okc_k_headers_b khr

1335: --SELECT NVL(SUM(aps.amount_due_original), 0) interest_billed_amount
1336: --FROM okl_bpd_tld_ar_lines_v tld,
1337: --okl_strm_type_b sty,
1338: --ar_payment_schedules_all aps,
1339: --okc_k_headers_b khr
1340: --WHERE tld.khr_id = cp_khr_id
1341: --AND tld.khr_id = khr.id
1342: --AND tld.sty_id = sty.id
1343: --AND sty.stream_type_purpose = 'FLOAT_FACTOR_ADJUSTMENT'

Line 1805: FROM OKC_K_HEADERS_B chr,

1801:
1802: CURSOR l_date_csr(cp_khr_id IN NUMBER) IS
1803: SELECT chr.start_date,
1804: chr.end_date
1805: FROM OKC_K_HEADERS_B chr,
1806: OKL_K_HEADERS khr
1807: WHERE chr.id = khr.id
1808: AND khr.id = cp_khr_id;
1809:

Line 2324: okc_k_headers_b chr

2320: pdt.name pdt_name,
2321: chr.scs_code
2322: FROM okl_k_headers khr,
2323: okl_products pdt,
2324: okc_k_headers_b chr
2325: WHERE khr.id = p_chr_id
2326: AND chr.id = khr.id
2327: AND khr.pdt_id = pdt.id;
2328:

Line 2513: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;

2509: p_khr_id IN NUMBER,
2510: x_return_status OUT NOCOPY VARCHAR2) IS
2511:
2512: l_chr_streams_exist VARCHAR2(1) := 'N';
2513: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
2514:
2515: CURSOR check_chr_streams_csr (p_khr_id IN NUMBER) IS
2516: SELECT 'Y',
2517: chr.contract_number

Line 2521: ,okc_k_headers_b chr

2517: chr.contract_number
2518: FROM okl_strm_elements sel
2519: ,okl_streams str
2520: ,okl_strm_type_b sty
2521: ,okc_k_headers_b chr
2522: WHERE chr.id = p_khr_id
2523: AND sel.stm_id = str.id
2524: AND str.khr_id = chr.id
2525: AND str.kle_id IS NULL