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_INTEREST_PVT dependencies on OKL_STRM_ELEMENTS

Line 944: okl_strm_elements sel,

940: select NVL(sum(sel.amount), 0) amount
941: from
942: okl_K_lines_full_v kle,
943: okc_statuses_b sts,
944: okl_strm_elements sel,
945: okl_streams stm,
946: okl_strm_type_b sty
947: WHERE kle.dnz_chr_id = p_chr_id
948: AND kle.id = p_kle_id

Line 965: FROM okl_strm_elements sele,

961: ln_future_rents_rec ln_future_rents_csr%ROWTYPE;
962:
963: Cursor l_chr_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2) IS
964: SELECT NVL(SUM(sele.amount),0) amount
965: FROM okl_strm_elements sele,
966: okl_streams str,
967: okl_strm_type_b sty
968: WHERE sele.stm_id = str.id
969: AND str.sty_id = sty.id

Line 1045: okl_strm_elements sel,

1041: select NVL(sum(sel.amount), 0) amount
1042: from
1043: okl_K_lines_full_v kle,
1044: okc_statuses_b sts,
1045: okl_strm_elements sel,
1046: okl_streams stm,
1047: okl_strm_type_b sty
1048: WHERE kle.dnz_chr_id = p_chr_id
1049: AND kle.id = p_kle_id

Line 1510: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty

1506: c_khr_type_rec c_khr_type%ROWTYPE;
1507:
1508: /* CURSOR c_principal_bal_cur(p_contract_id NUMBER, p_bal_date DATE) IS
1509: SELECT sum(sel.amount) amount
1510: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty
1511: WHERE stm.khr_id = p_contract_id
1512: AND stm.active_yn = 'Y'
1513: AND stm.say_code = 'CURR'
1514: AND sty.id = stm.sty_id

Line 1518: FROM okl_strm_elements sel,okl_streams stm,

1514: AND sty.id = stm.sty_id
1515: AND sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
1516: AND sel.stm_id = stm.id
1517: and trunc(sel.stream_element_date) = ( select trunc(max(sel.stream_element_date))
1518: FROM okl_strm_elements sel,okl_streams stm,
1519: okl_strm_type_b sty
1520: WHERE stm.khr_id = p_contract_id
1521: AND stm.active_yn = 'Y'
1522: AND stm.say_code = 'CURR'

Line 1530: FROM okl_strm_elements sel,okl_streams stm,

1526: and trunc(sel.stream_element_date) <= p_bal_date);
1527:
1528: CURSOR c_stream_date_arr(p_contract_id NUMBER, p_bal_date DATE) IS
1529: select trunc(min(sel.stream_element_date))
1530: FROM okl_strm_elements sel,okl_streams stm,
1531: okl_strm_type_b sty
1532: WHERE stm.khr_id = p_contract_id
1533: AND stm.active_yn = 'Y'
1534: AND stm.say_code = 'CURR'

Line 1914: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty,

1910: AND val.datetime_valid < p_end_date);
1911:
1912: CURSOR c_calc_start_date (c_contract_id NUMBER)IS
1913: select min(sel.stream_element_date)
1914: FROM okl_strm_elements sel,okl_streams stm, okl_strm_type_b sty,
1915: okl_k_headers khr, okc_k_headers_b chr
1916: WHERE stm.khr_id = c_contract_id
1917: AND stm.active_yn = 'Y'
1918: AND stm.say_code = 'CURR'

Line 2271: l_ste_amount okl_strm_elements.amount%type;

2267: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
2268: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
2269:
2270: l_curr_code okc_k_headers_b.currency_code%TYPE;
2271: l_ste_amount okl_strm_elements.amount%type;
2272:
2273:
2274: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
2275: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;

Line 2329: FROM OKL_STRM_ELEMENTS_V

2325: AND stm.sty_id = p_sty_id;
2326:
2327: CURSOR c_stm_id_line_number(c_stm_id NUMBER) IS
2328: SELECT SE_LINE_NUMBER
2329: FROM OKL_STRM_ELEMENTS_V
2330: WHERE stm_id = c_stm_id
2331: ORDER BY SE_LINE_NUMBER DESC;
2332:
2333: CURSOR c_tran_num_csr IS

Line 2918: ----------- added by bv to populate mandatory field in table Okl_Strm_Elements.

2914: l_selv_rec.stream_element_date := l_due_date;
2915: l_selv_rec.date_billed := SYSDATE;
2916: l_selv_rec.amount := lx_interest_rec.interest_amount;
2917:
2918: ----------- added by bv to populate mandatory field in table Okl_Strm_Elements.
2919: l_selv_rec.se_line_number := NULL;
2920: OPEN c_stm_id_line_number(l_selv_rec.stm_id);
2921: FETCH c_stm_id_line_number INTO l_selv_rec.se_line_number;
2922: if(c_stm_id_line_number%rowcount = 0) THEN

Line 3213: ,okl_strm_elements_v sel_int_pmt

3209: p_stream_element_date DATE) IS
3210: SELECT nvl(sel_int_pmt.amount, 0) interest
3211: FROM okl_strm_type_v sty_int_pmt
3212: ,okl_streams_v stm_int_pmt
3213: ,okl_strm_elements_v sel_int_pmt
3214: WHERE stm_int_pmt.kle_id = p_line_id
3215: AND stm_int_pmt.id = sel_int_pmt.stm_id
3216: AND sel_int_pmt.stream_element_date = p_stream_element_date
3217: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 3227: ,okl_strm_elements_v sel_prin_pmt

3223: p_stream_element_date DATE) IS
3224: SELECT nvl(sel_prin_pmt.amount, 0) principal
3225: FROM okl_strm_type_v sty_prin_pmt
3226: ,okl_streams_v stm_prin_pmt
3227: ,okl_strm_elements_v sel_prin_pmt
3228: WHERE stm_prin_pmt.kle_id = p_line_id
3229: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3230: AND sel_prin_pmt.stream_element_date = p_stream_element_date
3231: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 3236: l_interest okl_strm_elements_v.amount%TYPE;

3232: AND stm_prin_pmt.active_yn = 'Y'
3233: AND stm_prin_pmt.say_code = 'CURR'
3234: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3235:
3236: l_interest okl_strm_elements_v.amount%TYPE;
3237: l_principal okl_strm_elements_v.amount%TYPE;
3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3239: BEGIN
3240: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);

Line 3237: l_principal okl_strm_elements_v.amount%TYPE;

3233: AND stm_prin_pmt.say_code = 'CURR'
3234: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3235:
3236: l_interest okl_strm_elements_v.amount%TYPE;
3237: l_principal okl_strm_elements_v.amount%TYPE;
3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3239: BEGIN
3240: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);
3241: FETCH stream_element_interest_csr INTO l_interest;

Line 3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;

3234: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3235:
3236: l_interest okl_strm_elements_v.amount%TYPE;
3237: l_principal okl_strm_elements_v.amount%TYPE;
3238: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3239: BEGIN
3240: OPEN stream_element_interest_csr (p_line_id, p_stream_element_date);
3241: FETCH stream_element_interest_csr INTO l_interest;
3242: IF stream_element_interest_csr%NOTFOUND THEN

Line 3299: ,okl_strm_elements_v sel_int_pmt

3295: p_stream_element_date DATE) IS
3296: SELECT nvl(sel_int_pmt.amount, 0) interest
3297: FROM okl_strm_type_v sty_int_pmt
3298: ,okl_streams_v stm_int_pmt
3299: ,okl_strm_elements_v sel_int_pmt
3300: WHERE stm_int_pmt.kle_id = p_line_id
3301: AND stm_int_pmt.id = sel_int_pmt.stm_id
3302: AND sel_int_pmt.stream_element_date = p_stream_element_date
3303: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 3313: ,okl_strm_elements_v sel_prin_pmt

3309: p_stream_element_date DATE) IS
3310: SELECT nvl(sel_prin_pmt.amount, 0) principal
3311: FROM okl_strm_type_v sty_prin_pmt
3312: ,okl_streams_v stm_prin_pmt
3313: ,okl_strm_elements_v sel_prin_pmt
3314: WHERE stm_prin_pmt.kle_id = p_line_id
3315: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3316: AND sel_prin_pmt.stream_element_date = p_stream_element_date
3317: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 3327: ,okl_strm_elements_v sel_int_pmt

3323: p_stream_element_date DATE) IS
3324: SELECT nvl(sel_int_pmt.amount, 0) interest
3325: FROM okl_strm_type_v sty_int_pmt
3326: ,okl_streams_v stm_int_pmt
3327: ,okl_strm_elements_v sel_int_pmt
3328: WHERE stm_int_pmt.khr_id = p_khr_id
3329: AND stm_int_pmt.id = sel_int_pmt.stm_id
3330: AND sel_int_pmt.stream_element_date = p_stream_element_date
3331: AND stm_int_pmt.sty_id = sty_int_pmt.id

Line 3341: ,okl_strm_elements_v sel_prin_pmt

3337: p_stream_element_date DATE) IS
3338: SELECT nvl(sel_prin_pmt.amount, 0) principal
3339: FROM okl_strm_type_v sty_prin_pmt
3340: ,okl_streams_v stm_prin_pmt
3341: ,okl_strm_elements_v sel_prin_pmt
3342: WHERE stm_prin_pmt.khr_id = p_khr_id
3343: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
3344: AND sel_prin_pmt.stream_element_date = p_stream_element_date
3345: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 3350: l_interest okl_strm_elements_v.amount%TYPE;

3346: AND stm_prin_pmt.active_yn = 'Y'
3347: AND stm_prin_pmt.say_code = 'CURR'
3348: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3349:
3350: l_interest okl_strm_elements_v.amount%TYPE;
3351: l_principal okl_strm_elements_v.amount%TYPE;
3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3353: BEGIN
3354: IF (p_line_id IS NOT NULL) THEN

Line 3351: l_principal okl_strm_elements_v.amount%TYPE;

3347: AND stm_prin_pmt.say_code = 'CURR'
3348: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3349:
3350: l_interest okl_strm_elements_v.amount%TYPE;
3351: l_principal okl_strm_elements_v.amount%TYPE;
3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3353: BEGIN
3354: IF (p_line_id IS NOT NULL) THEN
3355: OPEN strm_elem_int_line_csr (p_line_id, p_stream_element_date);

Line 3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;

3348: AND sty_prin_pmt.stream_type_purpose = 'PRINCIPAL_PAYMENT';
3349:
3350: l_interest okl_strm_elements_v.amount%TYPE;
3351: l_principal okl_strm_elements_v.amount%TYPE;
3352: l_prorated_principal okl_strm_elements_v.amount%TYPE;
3353: BEGIN
3354: IF (p_line_id IS NOT NULL) THEN
3355: OPEN strm_elem_int_line_csr (p_line_id, p_stream_element_date);
3356: FETCH strm_elem_int_line_csr INTO l_interest;

Line 3582: okl_strm_elements_v sel_ln_pmt

3578: ar_payment_schedules_all aps,
3579: ar_receivable_applications_all raa,
3580: ar_cash_receipts_all cra,
3581: okl_strm_type_v sty_ln_pmt,
3582: okl_strm_elements_v sel_ln_pmt
3583: WHERE lsm.receivables_invoice_id > 0
3584: AND lsm.lln_id = lln.id
3585: AND lln.cnr_id = cnr.id
3586: AND cnr.trx_status_code = 'PROCESSED'

Line 4241: okl_strm_elements sel

4237: p_stream_element_date DATE) IS
4238:
4239: SELECT sel.amount
4240: FROM
4241: okl_strm_elements sel
4242: ,okl_streams str
4243: ,okl_strm_type_v sty
4244: WHERE sel.stm_id = str.id
4245: AND str.khr_id = p_contract_id

Line 4257: okl_strm_elements sel

4253: Cursor sch_ctr_prin_balance_csr (p_contract_id NUMBER,
4254: p_stream_element_date DATE) IS
4255: SELECT SUM(amount)
4256: FROM
4257: okl_strm_elements sel
4258: ,okl_streams str
4259: ,okl_strm_type_v sty
4260: WHERE sel.stm_id = str.id
4261: AND str.khr_id = p_contract_id

Line 4350: okl_strm_elements sel

4346: UNION
4347: SELECT sel.stream_element_date receipt_date,
4348: sum(sel.amount) principal_pmt_rcpt_amt
4349: FROM
4350: okl_strm_elements sel
4351: ,okl_streams str
4352: ,okl_strm_type_v sty
4353: WHERE sel.stm_id = str.id
4354: AND str.khr_id = p_contract_id

Line 4372: okl_strm_elements sel

4368: p_due_date DATE) IS
4369: SELECT sel.stream_element_date receipt_date,
4370: sum(sel.amount) principal_pmt_rcpt_amt
4371: FROM
4372: okl_strm_elements sel
4373: ,okl_streams str
4374: ,okl_strm_type_v sty
4375: WHERE sel.stm_id = str.id
4376: AND str.khr_id = p_contract_id

Line 4848: okl_strm_elements sel

4844: SELECT sel.stream_element_date txn_date,
4845: sum(sel.amount) txn_amount,
4846: 'R' txn_type
4847: FROM
4848: okl_strm_elements sel
4849: ,okl_streams str
4850: ,okl_strm_type_v sty
4851: WHERE sel.stm_id = str.id
4852: AND str.khr_id = p_contract_id

Line 5316: okl_strm_elements sel,

5312: l_ret_date DATE := NULL;
5313:
5314: CURSOR c_int_calc_date_csr(cp_khr_id NUMBER) IS SELECT (max(sel.stream_element_date) - 1) last_interest_calc_date
5315: FROM okl_streams stm,
5316: okl_strm_elements sel,
5317: okl_strm_type_b sty
5318: WHERE stm.khr_id = cp_khr_id
5319: AND stm.id = sel.stm_id
5320: AND stm.sty_id = sty.id

Line 6380: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_STRM_ELEMENTS_B';

6376: g_vir_tbl_counter := nvl(g_vir_tbl_counter,0) + 1;
6377: g_vir_tbl(g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
6378: g_vir_tbl(g_vir_tbl_counter).khr_id := p_contract_id;
6379: IF (G_CALC_METHOD_CODE = 'DAILY_INTEREST') THEN
6380: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_STRM_ELEMENTS_B';
6381: ELSIF (G_CALC_METHOD_CODE = 'REAMORT') THEN
6382: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';
6383: ELSE
6384: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_TRX_AR_INVOICES_V';

Line 6684: FROM OKL_STRM_ELEMENTS_V

6680: FROM dual;
6681:
6682: CURSOR c_stm_id_line_number(c_stm_id NUMBER) IS
6683: SELECT SE_LINE_NUMBER
6684: FROM OKL_STRM_ELEMENTS_V
6685: WHERE stm_id = c_stm_id
6686: ORDER BY SE_LINE_NUMBER DESC;
6687:
6688:

Line 7800: okl_strm_elements sel

7796: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7797: SELECT 'Y' return_value
7798: FROM okl_streams stm,
7799: okl_strm_type_b sty,
7800: okl_strm_elements sel
7801: WHERE stm.khr_id = cp_khr_id
7802: AND stm.sty_id = sty.id
7803: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
7804: AND stm.id = sel.stm_id

Line 7808: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

7804: AND stm.id = sel.stm_id
7805: AND sel.stream_element_date < cp_from_date
7806: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7807: WHERE vpb.khr_id = stm.khr_id
7808: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
7809: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7810: AND vpb.source_id = sel.id);
7811:
7812: --checks if newly created Principal Catchup stream elements exist

Line 7818: okl_strm_elements sel

7814: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7815: SELECT 'Y' return_value
7816: FROM okl_streams stm,
7817: okl_strm_type_b sty,
7818: okl_strm_elements sel
7819: WHERE stm.khr_id = cp_khr_id
7820: AND stm.sty_id = sty.id
7821: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'
7822: AND stm.id = sel.stm_id

Line 7826: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

7822: AND stm.id = sel.stm_id
7823: AND sel.stream_element_date < cp_from_date
7824: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
7825: WHERE vpb.khr_id = stm.khr_id
7826: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
7827: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7828: AND vpb.source_id = sel.id);
7829:
7830: --checks if newly created Receipt Application to PRINCIPAL_PAYMENT, UNSCHEDULED_PRINCIPAL_PAYMENT exist

Line 8086: , 'OKL_STRM_ELEMENTS_V' source_table

8082:
8083: --get the id's of Daily Interest - Principal stream elements
8084: CURSOR l_daily_int_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8085: SELECT sel.id source_id
8086: , 'OKL_STRM_ELEMENTS_V' source_table
8087: FROM okl_streams stm,
8088: okl_strm_type_b sty,
8089: okl_strm_elements sel
8090: WHERE stm.khr_id = cp_khr_id

Line 8089: okl_strm_elements sel

8085: SELECT sel.id source_id
8086: , 'OKL_STRM_ELEMENTS_V' source_table
8087: FROM okl_streams stm,
8088: okl_strm_type_b sty,
8089: okl_strm_elements sel
8090: WHERE stm.khr_id = cp_khr_id
8091: AND stm.sty_id = sty.id
8092: AND sty.stream_type_purpose = 'DAILY_INTEREST_PRINCIPAL'
8093: AND stm.id = sel.stm_id

Line 8098: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

8094: --AND sel.stream_element_date BETWEEN cp_from_date AND cp_to_date
8095: AND sel.stream_element_date <= cp_to_date
8096: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8097: WHERE vpb.khr_id = stm.khr_id
8098: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
8099: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8100: AND vpb.source_id = sel.id);
8101:
8102: --get the id's of Principal Catchup stream elements

Line 8105: , 'OKL_STRM_ELEMENTS_V' source_table

8101:
8102: --get the id's of Principal Catchup stream elements
8103: CURSOR l_prin_catch_strm_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8104: SELECT sel.id source_id
8105: , 'OKL_STRM_ELEMENTS_V' source_table
8106: FROM okl_streams stm,
8107: okl_strm_type_b sty,
8108: okl_strm_elements sel
8109: WHERE stm.khr_id = cp_khr_id

Line 8108: okl_strm_elements sel

8104: SELECT sel.id source_id
8105: , 'OKL_STRM_ELEMENTS_V' source_table
8106: FROM okl_streams stm,
8107: okl_strm_type_b sty,
8108: okl_strm_elements sel
8109: WHERE stm.khr_id = cp_khr_id
8110: AND stm.sty_id = sty.id
8111: AND sty.stream_type_purpose = 'PRINCIPAL_CATCHUP'
8112: AND stm.id = sel.stm_id

Line 8117: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'

8113: --AND sel.stream_element_date BETWEEN cp_from_date AND cp_to_date
8114: AND sel.stream_element_date <= cp_to_date
8115: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
8116: WHERE vpb.khr_id = stm.khr_id
8117: AND vpb.source_table = 'OKL_STRM_ELEMENTS_V'
8118: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8119: AND vpb.source_id = sel.id);
8120:
8121: --get the id's of Receipt Application to PRINCIPAL_PAYMENT, UNSCHEDULED_PRINCIPAL_PAYMENT

Line 9716: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

9712:
9713: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DAILY_INTEREST_STREAMS';
9714: l_api_version CONSTANT NUMBER := 1.0;
9715: l_invoice_id NUMBER;
9716: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
9717: i_vir_tbl vir_tbl_type;
9718: r_vir_tbl vir_tbl_type;
9719: Create_Daily_Int_Str_failed EXCEPTION;
9720: l_asset_cost NUMBER;

Line 10271: FROM okl_strm_elements sel,

10267: AND ppm.quality_name = 'INTEREST_CALCULATION_BASIS';
10268:
10269: /*CURSOR c_terms_cur (p_contract_id NUMBER, p_reamort_date DATE) IS
10270: SELECT max(sel.stream_element_date)
10271: FROM okl_strm_elements sel,
10272: okl_streams stm,
10273: okl_strm_type_b sty,
10274: okc_k_headers_b khr
10275: WHERE stm.khr_id = p_contract_id

Line 11240: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;

11236: l_interest_paid NUMBER := 0;
11237: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11238: i_vir_tbl vir_tbl_type;
11239: r_vir_tbl vir_tbl_type;
11240: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
11241:
11242: CURSOR loan_payment_amount_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11243: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11244: FROM okl_strm_type_v sty_prin_pmt,

Line 11246: okl_strm_elements_v sel_prin_pmt

11242: CURSOR loan_payment_amount_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11243: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11244: FROM okl_strm_type_v sty_prin_pmt,
11245: okl_streams_v stm_prin_pmt,
11246: okl_strm_elements_v sel_prin_pmt
11247: WHERE stm_prin_pmt.khr_id = p_khr_id
11248: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11249: AND sel_prin_pmt.stream_element_date <= p_due_date
11250: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11259: okl_strm_elements_v sel_prin_pmt

11255: CURSOR scheduled_prin_pmnt_amt_csr (p_khr_id NUMBER, p_due_date DATE, p_stream_type_purpose VARCHAR2) IS
11256: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11257: FROM okl_strm_type_v sty_prin_pmt,
11258: okl_streams_v stm_prin_pmt,
11259: okl_strm_elements_v sel_prin_pmt
11260: WHERE stm_prin_pmt.khr_id = p_khr_id
11261: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11262: AND sel_prin_pmt.stream_element_date = p_due_date
11263: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11495: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;

11491: l_interest_paid NUMBER := 0;
11492: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11493: i_vir_tbl vir_tbl_type;
11494: r_vir_tbl vir_tbl_type;
11495: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
11496: l_kle_id OKL_K_LINES.id%TYPE;
11497: l_strm_element_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
11498: l_parent_strm_element_id OKL_STRM_ELEMENTS.id%TYPE;
11499: var_int_float_failed EXCEPTION;

Line 11497: l_strm_element_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;

11493: i_vir_tbl vir_tbl_type;
11494: r_vir_tbl vir_tbl_type;
11495: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
11496: l_kle_id OKL_K_LINES.id%TYPE;
11497: l_strm_element_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
11498: l_parent_strm_element_id OKL_STRM_ELEMENTS.id%TYPE;
11499: var_int_float_failed EXCEPTION;
11500:
11501: CURSOR loan_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS

Line 11498: l_parent_strm_element_id OKL_STRM_ELEMENTS.id%TYPE;

11494: r_vir_tbl vir_tbl_type;
11495: l_stream_element_id OKL_STRM_ELEMENTS_v.id%TYPE;
11496: l_kle_id OKL_K_LINES.id%TYPE;
11497: l_strm_element_date OKL_STRM_ELEMENTS.stream_element_date%TYPE;
11498: l_parent_strm_element_id OKL_STRM_ELEMENTS.id%TYPE;
11499: var_int_float_failed EXCEPTION;
11500:
11501: CURSOR loan_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
11502: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt

Line 11505: okl_strm_elements_v sel_prin_pmt

11501: CURSOR loan_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
11502: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11503: FROM okl_strm_type_v sty_prin_pmt,
11504: okl_streams_v stm_prin_pmt,
11505: okl_strm_elements_v sel_prin_pmt
11506: WHERE stm_prin_pmt.khr_id = cp_khr_id
11507: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11508: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
11509: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11519: okl_strm_elements_v sel_prin_pmt

11515: CURSOR Interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
11516: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11517: FROM okl_strm_type_v sty_prin_pmt,
11518: okl_streams_v stm_prin_pmt,
11519: okl_strm_elements_v sel_prin_pmt
11520: WHERE stm_prin_pmt.khr_id = cp_khr_id
11521: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11522: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
11523: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11543: okl_strm_elements sel

11539: sel.stream_element_date,
11540: sel.amount
11541: FROM okl_strm_type_v sty,
11542: okl_streams str,
11543: okl_strm_elements sel
11544: WHERE sel.stm_id = str.id
11545: AND str.khr_id = cp_khr_id
11546: AND str.kle_id = cp_kle_id
11547: AND str.say_code = 'CURR'

Line 11554: FROM okl_strm_elements selc

11550: AND str.sty_id = sty.id
11551: AND sty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
11552: AND NOT EXISTS (
11553: SELECT 'X'
11554: FROM okl_strm_elements selc
11555: WHERE selc.sel_id = sel.id)
11556: ORDER BY stream_element_date;
11557:
11558:

Line 11563: okl_strm_elements_v sel_prin_pmt

11559: CURSOR scheduled_prin_pmnt_amt_csr (cp_khr_id NUMBER, cp_due_date DATE, cp_stream_type_purpose VARCHAR2) IS
11560: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
11561: FROM okl_strm_type_v sty_prin_pmt,
11562: okl_streams_v stm_prin_pmt,
11563: okl_strm_elements_v sel_prin_pmt
11564: WHERE stm_prin_pmt.khr_id = cp_khr_id
11565: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
11566: AND sel_prin_pmt.stream_element_date = cp_due_date
11567: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 11875: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

11871: l_formula_name OKL_FORMULAE_V.name%TYPE;
11872: l_line_id OKC_K_LINES_B.id%TYPE;
11873: l_stream_element_date DATE;
11874: l_invoice_id NUMBER;
11875: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
11876: var_int_float_factor_failed EXCEPTION;
11877:
11878: Cursor formula_name_csr (p_formula_id NUMBER) IS
11879: SELECT fml.name

Line 11888: okl_strm_elements selb, okl_streams stmb

11884: SELECT chrb.id contract_id, cleb.id kle_id,
11885: selb.stream_element_date, selb.amount amount
11886: FROM okc_k_headers_b chrb, okc_k_lines_b cleb,
11887: okc_line_styles_b lseb, okl_strm_type_b styb,
11888: okl_strm_elements selb, okl_streams stmb
11889: WHERE cleb.dnz_chr_id = chrb.id
11890: AND cleb.chr_id = chrb.id
11891: AND chrb.id = p_contract_id
11892: AND cleb.lse_id = lseb.id

Line 12132: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

12128: l_asset_line_tbl_count NUMBER := 0;
12129: l_prorated_invoice_amt NUMBER := 0;
12130: i_vir_tbl vir_tbl_type;
12131: r_vir_tbl vir_tbl_type;
12132: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
12133: var_int_catchup_failed EXCEPTION;
12134:
12135: CURSOR interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12136: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt

Line 12139: okl_strm_elements_v sel_prin_pmt

12135: CURSOR interest_payment_amount_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12136: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12137: FROM okl_strm_type_v sty_prin_pmt,
12138: okl_streams_v stm_prin_pmt,
12139: okl_strm_elements_v sel_prin_pmt
12140: WHERE stm_prin_pmt.khr_id = cp_khr_id
12141: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12142: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
12143: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 12152: okl_strm_elements_v sel_prin_pmt

12148: CURSOR int_pay_amt_end_date_csr (cp_khr_id NUMBER, cp_start_date DATE) IS
12149: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12150: FROM okl_strm_type_v sty_prin_pmt,
12151: okl_streams_v stm_prin_pmt,
12152: okl_strm_elements_v sel_prin_pmt
12153: WHERE stm_prin_pmt.khr_id = cp_khr_id
12154: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12155: AND sel_prin_pmt.stream_element_date >= cp_start_date
12156: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 12165: okl_strm_elements_v sel_prin_pmt

12161: CURSOR principal_adjustment_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE) IS
12162: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
12163: FROM okl_strm_type_v sty_prin_pmt,
12164: okl_streams_v stm_prin_pmt,
12165: okl_strm_elements_v sel_prin_pmt
12166: WHERE stm_prin_pmt.khr_id = cp_khr_id
12167: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
12168: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
12169: AND stm_prin_pmt.sty_id = sty_prin_pmt.id