APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_K_LINES_FULL_V

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