APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKC_STATUSES_B

Line 2209: OKC_STATUSES_B sts

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'
2212: AND kle.dnz_chr_id = chrid
2213: AND sts.code = kle.sts_code

Line 2220: OKC_STATUSES_B sts

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'
2223: AND kle.fee_type IN('FINANCED','ROLLOVER')
2224: AND kle.dnz_chr_id = chrid