APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_K_LINES_FULL_V

Line 2207: FROM OKL_K_LINES_FULL_V kle,

2203: l_fee_exists VARCHAR2(1) := 'N';
2204:
2205: CURSOR l_asset_lines_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
2206: SELECT kle.id
2207: FROM OKL_K_LINES_FULL_V kle,
2208: OKC_LINE_STYLES_B ls,
2209: OKC_STATUSES_B sts
2210: WHERE kle.lse_id = ls.id
2211: AND ls.lty_code = 'FREE_FORM1'

Line 2218: FROM OKL_K_LINES_FULL_V kle,

2214: AND sts.ste_code not in ( 'HOLD', 'EXPIRED', 'CANCELLED');
2215:
2216: CURSOR l_check_fee_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
2217: SELECT 'Y'
2218: FROM OKL_K_LINES_FULL_V kle,
2219: OKC_LINE_STYLES_B ls,
2220: OKC_STATUSES_B sts
2221: WHERE kle.lse_id = ls.id
2222: AND ls.lty_code = 'FEE'