APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKC_K_LINES_B

Line 969: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE

965: l_okl_last_ins_to_csr okl_last_ins_to_csr%ROWTYPE;
966:
967: CURSOR okl_k_capital_amt_csr (p_khr_id NUMBER) IS
968: SELECT SUM(KLE.CAPITAL_AMOUNT) --,SUM(KLE.OEC)
969: FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE
970: WHERE CLEB.ID = KLE.ID
971: AND CLEB.DNZ_CHR_ID = p_khr_id
972: AND CLEB.CLE_ID IS NULL
973: GROUP BY CLEB.DNZ_CHR_ID ;

Line 980: FROM OKC_K_LINES_B CLE ,

976: -- Fix for getting location based on install_base
977: -- install_location_type
978: CURSOR okl_financial_line_csr (p_khr_id NUMBER) IS
979: select cle.id
980: FROM OKC_K_LINES_B CLE ,
981: OKC_LINE_STYLES_B LST,
982: OKL_K_LINES kle
983: where cle.dnz_chr_id = p_khr_id
984: AND lst.lty_code ='FREE_FORM1'