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_FULL_V

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 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 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 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