APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_K_LINES

Line 942: okl_K_lines_full_v kle,

938:
939: Cursor ln_future_rents_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE, p_advance_or_arrears VARCHAR2 ) IS
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

Line 1043: okl_K_lines_full_v kle,

1039:
1040: Cursor l_chr_income_csr (p_chr_id NUMBER, p_kle_id NUMBER, p_date DATE) IS
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

Line 1120: okl_K_lines_full_v kle,

1116:
1117: Cursor residual_value_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
1118: SELECT nvl(kle.residual_value,0) Value
1119: FROM OKC_LINE_STYLES_B LS,
1120: okl_K_lines_full_v kle,
1121: okc_statuses_b sts
1122: WHERE LS.ID = KLE.LSE_ID
1123: AND LS.LTY_CODE ='FREE_FORM1'
1124: AND KLE.DNZ_CHR_ID = p_chr_id --289326506849179644190030423574805590144

Line 1188: okl_k_lines okl_line

1184: Cursor loan_asset_cost_csr (p_chr_id IN NUMBER) IS
1185: select sum(okl_line.capital_amount) asset_cost
1186: from okc_k_lines_b okc_line,
1187: okc_line_styles_b style,
1188: okl_k_lines okl_line
1189: where okc_line.chr_id = p_chr_id --276779267018378275653765386722943545472
1190: and okc_line.lse_id = style.id
1191: and style.lty_code = 'FREE_FORM1'
1192: and okc_line.id = okl_line.id;

Line 9732: FROM okl_k_lines_full_v

9728:
9729:
9730: CURSOR contract_line_csr (p_khr_id NUMBER, p_due_date DATE) IS
9731: SELECT id
9732: FROM okl_k_lines_full_v
9733: WHERE chr_id = p_khr_id
9734: AND lse_id = G_FIN_LINE_LTY_ID
9735: AND nvl(date_terminated, p_due_date + 1) > p_due_date
9736: ORDER BY id;

Line 10310: l_line_id_buf okl_k_lines.id%type := -1;

10306: FROM okl_k_headers_full_v
10307: WHERE id = p_contract_id;
10308: -- End by prasjain bug# 6142095
10309: --start | 19-May-08 cklee fixed Bug 7043360 |
10310: l_line_id_buf okl_k_lines.id%type := -1;
10311: --end | 19-May-08 cklee fixed Bug 7043360 |
10312:
10313: BEGIN
10314:

Line 11496: l_kle_id OKL_K_LINES.id%TYPE;

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;
11500:

Line 11531: FROM okl_k_lines_full_v

11527: AND sty_prin_pmt.stream_type_purpose = 'VARIABLE_LOAN_PAYMENT';
11528:
11529: CURSOR contract_line_csr (cp_khr_id NUMBER, cp_due_date DATE) IS
11530: SELECT id
11531: FROM okl_k_lines_full_v
11532: WHERE chr_id = cp_khr_id
11533: AND lse_id = G_FIN_LINE_LTY_ID
11534: AND nvl(date_terminated, cp_due_date + 1) > cp_due_date
11535: ORDER BY id;

Line 12184: FROM okl_k_lines_full_v

12180: AND parameter_type_code = 'ACTUAL';
12181: */
12182: CURSOR contract_line_csr (p_khr_id NUMBER) IS
12183: SELECT id
12184: FROM okl_k_lines_full_v
12185: WHERE chr_id = p_khr_id
12186: AND lse_id = G_FIN_LINE_LTY_ID
12187: ORDER BY id;
12188: BEGIN