eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_K_HEADERS

Line 43: okl_k_headers_full_v khr

39: --dcshanmu bug 6734738 end
40: FROM okl_bpd_ar_inv_lines_v lpt,
41: okl_strm_type_b sty,
42: ar_payment_schedules_all aps,
43: okl_k_headers_full_v khr
44: --dcshanmu bug 6734738 start
45: WHERE lpt.contract_id = cp_khr_id
46: --dcshanmu bug 6734738 end
47: AND lpt.contract_number = khr.contract_number

Line 68: -- okl_k_headers_full_v khr

64: -- SELECT NVL(SUM(aps.amount_line_items_original),0) interest_billed_amount --End bug# 5767426
65: -- FROM okl_bpd_tld_ar_lines_v tld,
66: -- okl_strm_type_b sty,
67: -- ar_payment_schedules_all aps,
68: -- okl_k_headers_full_v khr
69: -- WHERE tld.khr_id = cp_khr_id
70: -- AND tld.khr_id = khr.id
71: -- AND tld.sty_id = sty.id
72: -- AND sty.stream_type_purpose IN ('INTEREST_PAYMENT', 'VARIABLE_INTEREST','INTEREST_CATCHUP')

Line 87: okl_k_headers_full_v khr

83: FROM okl_cnsld_ar_strms_b lsm,
84: okl_strm_type_v sty,
85: okl_strm_elements sel,
86: ar_payment_schedules_all aps,
87: okl_k_headers_full_v khr
88: WHERE lsm.khr_id = cp_khr_id
89: AND lsm.khr_id = khr.id
90: AND lsm.sty_id = sty.id
91: AND sty.stream_type_purpose = 'VARIABLE_LOAN_PAYMENT'

Line 179: okl_k_headers_full_v khr

175: FROM
176: okl_bpd_ar_inv_lines_v lpt,
177: okl_strm_type_b sty,
178: ar_payment_schedules_all aps,
179: okl_k_headers_full_v khr
180: WHERE
181: lpt.contract_id = lpt1.contract_id
182: AND lpt.contract_number = khr.contract_number
183: AND lpt.sty_id = sty.id

Line 215: --okl_k_headers_full_v khr

211: --ar_cash_receipts_all cra,
212: --ar_payment_schedules_all sch,
213: --okl_bpd_tld_ar_lines_v tld,
214: --okl_strm_type_v sty,
215: --okl_k_headers_full_v khr
216: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
217: --AND app.status = 'APP'
218: --AND app.applied_payment_schedule_id = sch.payment_schedule_id
219: --AND app.cash_receipt_id = cra.cash_receipt_id

Line 331: OKL_K_HEADERS khr

327: SELECT chr.start_date,
328: chr.currency_code,
329: chr.end_date
330: FROM OKC_K_HEADERS_B chr,
331: OKL_K_HEADERS khr
332: WHERE chr.id = khr.id
333: AND khr.id = cp_khr_id;
334:
335: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS

Line 338: FROM okl_k_headers khr,

334:
335: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
336: SELECT ppm.interest_calculation_basis
337: ,ppm.revenue_recognition_method
338: FROM okl_k_headers khr,
339: okl_product_parameters_v ppm
340: WHERE khr.id = cp_khr_id
341: AND khr.pdt_id = ppm.id;
342:

Line 565: okl_k_headers khr,

561:
562: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS
563: SELECT chr.start_date, rpm.principal_basis_code
564: FROM okc_k_headers_b chr,
565: okl_k_headers khr,
566: okl_k_rate_params rpm
567: WHERE chr.id = khr.id
568: AND rpm.khr_id = khr.id
569: AND rpm.parameter_type_code = 'ACTUAL'

Line 610: FROM okl_k_headers khr,

606: --change for bug fix 4905791
607: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
608: SELECT ppm.interest_calculation_basis
609: ,ppm.revenue_recognition_method
610: FROM okl_k_headers khr,
611: okl_product_parameters_v ppm
612: WHERE khr.id = cp_khr_id
613: AND khr.pdt_id = ppm.id;
614:

Line 618: FROM okl_k_headers

614:
615: -- sechawla 02-may-08 6939451 Addec this cursor
616: Cursor contract_csr (p_contract_id NUMBER) IS
617: SELECT deal_type
618: FROM okl_k_headers
619: WHERE id = p_contract_id;
620:
621: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
622: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

Line 810: okl_k_headers_full_v khr

806: FROM
807: okl_bpd_ar_inv_lines_v lpt,
808: okl_strm_type_b sty,
809: ar_payment_schedules_all aps,
810: okl_k_headers_full_v khr
811: WHERE
812: lpt.contract_id = lpt1.contract_id
813: AND lpt.contract_number = khr.contract_number
814: AND lpt.sty_id = sty.id

Line 849: --okl_k_headers_full_v khr

845: --ar_cash_receipts_all cra,
846: --ar_payment_schedules_all sch,
847: --okl_bpd_tld_ar_lines_v tld,
848: --okl_strm_type_v sty,
849: --okl_k_headers_full_v khr
850: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
851: --AND app.cash_receipt_id = cra.cash_receipt_id
852: --AND app.status = 'APP'
853: --AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1028: FROM okl_k_headers_full_v khr,

1024: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
1025: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
1026: SELECT ppm.quality_val interest_calculation_basis
1027: , end_date
1028: FROM okl_k_headers_full_v khr,
1029: okl_prod_qlty_val_uv ppm
1030: WHERE khr.pdt_id = ppm.pdt_id
1031: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS'
1032: AND khr.id = cp_khr_id;

Line 1043: l_end_date okl_k_headers_full_v.end_date%TYPE;

1039:
1040: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
1041: l_effective_int_rate NUMBER;
1042: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;
1043: l_end_date okl_k_headers_full_v.end_date%TYPE;
1044: l_effective_date DATE := NULL;
1045:
1046: BEGIN
1047: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 1148: OKL_K_HEADERS khr

1144:
1145: CURSOR l_start_date_csr(cp_khr_id IN NUMBER) IS
1146: SELECT chr.start_date
1147: FROM OKC_K_HEADERS_B chr,
1148: OKL_K_HEADERS khr
1149: WHERE chr.id = khr.id
1150: AND khr.id = cp_khr_id;
1151: BEGIN
1152: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 1259: okl_k_headers_full_v khr

1255: -- dcshanmu bug 6734738 end
1256: FROM okl_bpd_ar_inv_lines_v lpt,
1257: okl_strm_type_b sty,
1258: ar_payment_schedules_all aps,
1259: okl_k_headers_full_v khr
1260: WHERE
1261: -- dcshanmu bug 6734738 start
1262: lpt.contract_id = cp_khr_id
1263: -- dcshanmu bug 6734738 end

Line 1282: --okl_k_headers_full_v khr

1278: --SELECT NVL(sum(aps.amount_line_items_original), 0) principal_billed_amount --End bug#5767426
1279: --FROM okl_bpd_tld_ar_lines_v tld,
1280: --okl_strm_type_b sty,
1281: --ar_payment_schedules_all aps,
1282: --okl_k_headers_full_v khr
1283: --WHERE tld.khr_id = cp_khr_id
1284: --AND tld.kle_id = NVL(cp_kle_id, tld.kle_id)
1285: --AND tld.khr_id = khr.id
1286: --AND tld.sty_id = sty.id

Line 1373: okl_k_headers_full_v khr

1369: SELECT lpt.RECEIVABLES_INVOICE_ID
1370: FROM okl_bpd_ar_inv_lines_v lpt,
1371: okl_strm_type_b sty,
1372: ar_payment_schedules_all aps,
1373: okl_k_headers_full_v khr
1374: WHERE lpt.contract_id = lpt1.contract_id
1375: AND lpt.contract_number = khr.contract_number
1376: AND lpt.sty_id = sty.id
1377: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1474: okl_k_headers_full_v khr

1470: SELECT lpt.RECEIVABLES_INVOICE_ID
1471: FROM okl_bpd_ar_inv_lines_v lpt,
1472: okl_strm_type_b sty,
1473: ar_payment_schedules_all aps,
1474: okl_k_headers_full_v khr
1475: WHERE lpt.contract_id = lpt1.contract_id
1476: AND lpt.contract_number = khr.contract_number
1477: AND lpt.sty_id = sty.id
1478: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1487: --okl_k_headers_full_v khr

1483: --SELECT NVL(SUM(aps.amount_due_original), 0) loan_billed_amount
1484: --FROM okl_bpd_tld_ar_lines_v tld,
1485: --okl_strm_type_b sty,
1486: --ar_payment_schedules_all aps,
1487: --okl_k_headers_full_v khr
1488: --WHERE tld.khr_id = cp_khr_id
1489: --AND tld.khr_id = khr.id
1490: --AND tld.sty_id = sty.id
1491: --AND sty.stream_type_purpose IN ('LOAN_PAYMENT', 'VARIABLE_LOAN_PAYMENT', 'UNSCHEDULED_LOAN_PAYMENT')

Line 1577: okl_k_headers_full_v khr

1573: SELECT lpt.RECEIVABLES_INVOICE_ID
1574: FROM okl_bpd_ar_inv_lines_v lpt,
1575: okl_strm_type_b sty,
1576: ar_payment_schedules_all aps,
1577: okl_k_headers_full_v khr
1578: WHERE lpt.contract_id = lpt1.contract_id
1579: AND lpt.contract_number = khr.contract_number
1580: AND lpt.sty_id = sty.id
1581: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1592: --okl_k_headers_full_v khr

1588: --FROM ar_receivable_applications_all app,
1589: --ar_payment_schedules_all sch,
1590: --okl_bpd_tld_ar_lines_v tld,
1591: --okl_strm_type_v sty,
1592: --okl_k_headers_full_v khr
1593: --WHERE TRUNC(app.apply_date) <= cp_effective_date
1594: --AND app.status = 'APP'
1595: --AND app.applied_payment_schedule_id = sch.payment_schedule_id
1596: --AND sch.class = 'INV'

Line 1748: FROM okl_k_headers

1744: l_last_interest_date DATE;
1745:
1746: CURSOR l_interest_calc_date_csr (cp_khr_id IN NUMBER) IS
1747: SELECT date_last_interim_interest_cal
1748: FROM okl_k_headers
1749: WHERE id = cp_khr_id;
1750: BEGIN
1751: l_debug_enabled := okl_debug_pub.check_log_enabled;
1752: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 1827: FROM okl_k_headers

1823: l_next_period_end_date DATE;
1824:
1825: CURSOR l_pdt_csr(cp_khr_id IN NUMBER) IS
1826: SELECT pdt_id
1827: FROM okl_k_headers
1828: WHERE id = cp_khr_id;
1829:
1830: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1831: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq

Line 1853: OKL_K_HEADERS khr

1849: CURSOR l_date_csr(cp_khr_id IN NUMBER) IS
1850: SELECT chr.start_date,
1851: chr.end_date
1852: FROM OKC_K_HEADERS_B chr,
1853: OKL_K_HEADERS khr
1854: WHERE chr.id = khr.id
1855: AND khr.id = cp_khr_id;
1856:
1857: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS

Line 2051: okl_k_headers_full_v khr

2047: FROM
2048: okl_bpd_ar_inv_lines_v lpt,
2049: okl_strm_type_b sty,
2050: ar_payment_schedules_all aps,
2051: okl_k_headers_full_v khr
2052: WHERE
2053: lpt.CONTRACT_ID = cp_khr_id
2054: AND lpt.contract_number = khr.contract_number
2055: AND lpt.sty_id = sty.id