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 40: okl_k_headers_full_v khr

36: SELECT NVL(SUM(AMOUNT),0) interest_billed_amount
37: FROM okl_bpd_ar_inv_lines_v lpt,
38: okl_strm_type_b sty,
39: ar_payment_schedules_all aps,
40: okl_k_headers_full_v khr
41: WHERE lpt.contract_id = cp_khr_id
42: AND (cp_kle_id IS NULL OR (cp_kle_id IS NOT NULL AND lpt.contract_line_id = cp_kle_id))
43: AND lpt.contract_number = khr.contract_number
44: AND lpt.sty_id = sty.id

Line 245: OKL_K_HEADERS khr

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:
249: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS

Line 252: FROM okl_k_headers khr,

248:
249: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
250: SELECT ppm.interest_calculation_basis
251: ,ppm.revenue_recognition_method
252: FROM okl_k_headers khr,
253: okl_product_parameters_v ppm
254: WHERE khr.id = cp_khr_id
255: AND khr.pdt_id = ppm.id;
256:

Line 479: okl_k_headers khr,

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
483: AND rpm.parameter_type_code = 'ACTUAL'

Line 524: FROM okl_k_headers khr,

520: --change for bug fix 4905791
521: CURSOR l_int_calc_basis_csr(cp_khr_id IN NUMBER) IS
522: SELECT ppm.interest_calculation_basis
523: ,ppm.revenue_recognition_method
524: FROM okl_k_headers khr,
525: okl_product_parameters_v ppm
526: WHERE khr.id = cp_khr_id
527: AND khr.pdt_id = ppm.id;
528:

Line 532: FROM okl_k_headers

528:
529: -- sechawla 02-may-08 6939451 Addec this cursor
530: Cursor contract_csr (p_contract_id NUMBER) IS
531: SELECT deal_type
532: FROM okl_k_headers
533: WHERE id = p_contract_id;
534:
535: l_int_calc_basis OKL_PRODUCT_PARAMETERS_V.interest_calculation_basis%TYPE;
536: l_rev_rec_mthd OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

Line 761: okl_k_headers_full_v khr

757: FROM
758: okl_bpd_ar_inv_lines_v lpt,
759: okl_strm_type_b sty,
760: ar_payment_schedules_all aps,
761: okl_k_headers_full_v khr
762: WHERE
763: lpt.contract_id = lpt1.contract_id
764: AND lpt.contract_number = khr.contract_number
765: AND lpt.sty_id = sty.id

Line 802: --okl_k_headers_full_v khr

798: --ar_cash_receipts_all cra,
799: --ar_payment_schedules_all sch,
800: --okl_bpd_tld_ar_lines_v tld,
801: --okl_strm_type_v sty,
802: --okl_k_headers_full_v khr
803: --WHERE TRUNC(cra.receipt_date) BETWEEN TRUNC(NVL(cp_from_date, cra.receipt_date)) AND TRUNC(NVL(cp_to_date, SYSDATE))
804: --AND app.cash_receipt_id = cra.cash_receipt_id
805: --AND app.status = 'APP'
806: --AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 981: FROM okl_k_headers_full_v khr,

977: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
978: CURSOR l_calc_basis_csr(cp_khr_id IN NUMBER) IS
979: SELECT ppm.quality_val interest_calculation_basis
980: , end_date
981: FROM okl_k_headers_full_v khr,
982: okl_prod_qlty_val_uv ppm
983: WHERE khr.pdt_id = ppm.pdt_id
984: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS'
985: AND khr.id = cp_khr_id;

Line 996: l_end_date okl_k_headers_full_v.end_date%TYPE;

992:
993: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
994: l_effective_int_rate NUMBER;
995: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;
996: l_end_date okl_k_headers_full_v.end_date%TYPE;
997: l_effective_date DATE := NULL;
998:
999: BEGIN
1000: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 1101: OKL_K_HEADERS khr

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
1105: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 1212: okl_k_headers_full_v khr

1208: -- dcshanmu bug 6734738 end
1209: FROM okl_bpd_ar_inv_lines_v lpt,
1210: okl_strm_type_b sty,
1211: ar_payment_schedules_all aps,
1212: okl_k_headers_full_v khr
1213: WHERE
1214: -- dcshanmu bug 6734738 start
1215: lpt.contract_id = cp_khr_id
1216: -- dcshanmu bug 6734738 end

Line 1235: --okl_k_headers_full_v khr

1231: --SELECT NVL(sum(aps.amount_line_items_original), 0) principal_billed_amount --End bug#5767426
1232: --FROM okl_bpd_tld_ar_lines_v tld,
1233: --okl_strm_type_b sty,
1234: --ar_payment_schedules_all aps,
1235: --okl_k_headers_full_v khr
1236: --WHERE tld.khr_id = cp_khr_id
1237: --AND tld.kle_id = NVL(cp_kle_id, tld.kle_id)
1238: --AND tld.khr_id = khr.id
1239: --AND tld.sty_id = sty.id

Line 1326: okl_k_headers_full_v khr

1322: SELECT lpt.RECEIVABLES_INVOICE_ID
1323: FROM okl_bpd_ar_inv_lines_v lpt,
1324: okl_strm_type_b sty,
1325: ar_payment_schedules_all aps,
1326: okl_k_headers_full_v khr
1327: WHERE lpt.contract_id = lpt1.contract_id
1328: AND lpt.contract_number = khr.contract_number
1329: AND lpt.sty_id = sty.id
1330: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1427: okl_k_headers_full_v khr

1423: SELECT lpt.RECEIVABLES_INVOICE_ID
1424: FROM okl_bpd_ar_inv_lines_v lpt,
1425: okl_strm_type_b sty,
1426: ar_payment_schedules_all aps,
1427: okl_k_headers_full_v khr
1428: WHERE lpt.contract_id = lpt1.contract_id
1429: AND lpt.contract_number = khr.contract_number
1430: AND lpt.sty_id = sty.id
1431: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1440: --okl_k_headers_full_v khr

1436: --SELECT NVL(SUM(aps.amount_due_original), 0) loan_billed_amount
1437: --FROM okl_bpd_tld_ar_lines_v tld,
1438: --okl_strm_type_b sty,
1439: --ar_payment_schedules_all aps,
1440: --okl_k_headers_full_v khr
1441: --WHERE tld.khr_id = cp_khr_id
1442: --AND tld.khr_id = khr.id
1443: --AND tld.sty_id = sty.id
1444: --AND sty.stream_type_purpose IN ('LOAN_PAYMENT', 'VARIABLE_LOAN_PAYMENT', 'UNSCHEDULED_LOAN_PAYMENT')

Line 1530: okl_k_headers_full_v khr

1526: SELECT lpt.RECEIVABLES_INVOICE_ID
1527: FROM okl_bpd_ar_inv_lines_v lpt,
1528: okl_strm_type_b sty,
1529: ar_payment_schedules_all aps,
1530: okl_k_headers_full_v khr
1531: WHERE lpt.contract_id = lpt1.contract_id
1532: AND lpt.contract_number = khr.contract_number
1533: AND lpt.sty_id = sty.id
1534: AND lpt.RECEIVABLES_INVOICE_ID = aps.customer_trx_id

Line 1545: --okl_k_headers_full_v khr

1541: --FROM ar_receivable_applications_all app,
1542: --ar_payment_schedules_all sch,
1543: --okl_bpd_tld_ar_lines_v tld,
1544: --okl_strm_type_v sty,
1545: --okl_k_headers_full_v khr
1546: --WHERE TRUNC(app.apply_date) <= cp_effective_date
1547: --AND app.status = 'APP'
1548: --AND app.applied_payment_schedule_id = sch.payment_schedule_id
1549: --AND sch.class = 'INV'

Line 1701: FROM okl_k_headers

1697: l_last_interest_date DATE;
1698:
1699: CURSOR l_interest_calc_date_csr (cp_khr_id IN NUMBER) IS
1700: SELECT date_last_interim_interest_cal
1701: FROM okl_k_headers
1702: WHERE id = cp_khr_id;
1703: BEGIN
1704: l_debug_enabled := okl_debug_pub.check_log_enabled;
1705: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 1780: FROM okl_k_headers

1776: l_next_period_end_date DATE;
1777:
1778: CURSOR l_pdt_csr(cp_khr_id IN NUMBER) IS
1779: SELECT pdt_id
1780: FROM okl_k_headers
1781: WHERE id = cp_khr_id;
1782:
1783: CURSOR l_payment_freq_csr(cp_khr_id IN NUMBER) IS
1784: SELECT DECODE(sll.object1_id1,'M',1,'Q',3,'S',6,'A',12) pay_freq

Line 1806: OKL_K_HEADERS khr

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:
1810: CURSOR l_stream_csr(cp_khr_id IN NUMBER, cp_term_date IN DATE) IS

Line 2127: okl_k_headers_full_v khr

2123: FROM
2124: okl_bpd_ar_inv_lines_v lpt,
2125: okl_strm_type_b sty,
2126: ar_payment_schedules_all aps,
2127: okl_k_headers_full_v khr
2128: WHERE
2129: lpt.CONTRACT_ID = cp_khr_id
2130: AND lpt.contract_number = khr.contract_number
2131: AND lpt.sty_id = sty.id

Line 2205: CURSOR l_asset_lines_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

2201: l_prin_payment_exists VARCHAR2(1) := 'N';
2202: l_prin_balance_exists VARCHAR2(1) := 'N';
2203: l_fee_exists VARCHAR2(1) := 'N';
2204:
2205: CURSOR l_asset_lines_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
2206: SELECT kle.id
2207: FROM OKL_K_LINES_FULL_V kle,
2208: OKC_LINE_STYLES_B ls,
2209: OKC_STATUSES_B sts

Line 2216: CURSOR l_check_fee_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

2212: AND kle.dnz_chr_id = chrid
2213: AND sts.code = kle.sts_code
2214: AND sts.ste_code not in ( 'HOLD', 'EXPIRED', 'CANCELLED');
2215:
2216: CURSOR l_check_fee_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
2217: SELECT 'Y'
2218: FROM OKL_K_LINES_FULL_V kle,
2219: OKC_LINE_STYLES_B ls,
2220: OKC_STATUSES_B sts

Line 2322: FROM okl_k_headers khr,

2318: CURSOR chr_csr(p_chr_id NUMBER) IS
2319: SELECT khr.pdt_id,
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