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_STREAMS_V

Line 3212: ,okl_streams_v stm_int_pmt

3208: Cursor stream_element_interest_csr (p_line_id NUMBER,
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

Line 3226: ,okl_streams_v stm_prin_pmt

3222: Cursor stream_element_principal_csr (p_line_id NUMBER,
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

Line 3298: ,okl_streams_v stm_int_pmt

3294: Cursor strm_elem_int_line_csr (p_line_id NUMBER,
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

Line 3312: ,okl_streams_v stm_prin_pmt

3308: Cursor strm_elem_prin_line_csr (p_line_id NUMBER,
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

Line 3326: ,okl_streams_v stm_int_pmt

3322: Cursor strm_elem_int_hdr_csr (p_khr_id NUMBER,
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

Line 3340: ,okl_streams_v stm_prin_pmt

3336: Cursor strm_elem_prin_hdr_csr ( p_khr_id NUMBER,
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

Line 11245: okl_streams_v stm_prin_pmt,

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

Line 11258: okl_streams_v stm_prin_pmt,

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

Line 11504: okl_streams_v stm_prin_pmt,

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

Line 11518: okl_streams_v stm_prin_pmt,

11514: -- Derive the interest billed for previous billing periods
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

Line 11562: okl_streams_v stm_prin_pmt,

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

Line 12138: okl_streams_v stm_prin_pmt,

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

Line 12151: okl_streams_v stm_prin_pmt,

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

Line 12164: okl_streams_v stm_prin_pmt,

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