DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKC_K_LINES_B

Line 2423: FROM okc_k_lines_b cleb,

2419: -- cursor : to check whether Contract is having mixed asset or not
2420: CURSOR l_chk_con_csr (chrid NUMBER) IS
2421: SELECT COUNT (*)
2422: FROM (SELECT COUNT(*)
2423: FROM okc_k_lines_b cleb,
2424: okl_k_lines kle
2425: WHERE kle.id = cleb.id
2426: AND cleb.chr_id = chrid
2427: --ndani - 27-Mar-2013 - Bug# 16552978 - Start

Line 2438: FROM okc_k_lines_b cleb,

2434:
2435: -- cursor : to check whether Contract is having re-lease assets
2436: CURSOR l_con_rel_csr (chrid NUMBER) IS
2437: SELECT DISTINCT NVL(kle.re_lease_yn,'N')
2438: FROM okc_k_lines_b cleb,
2439: okl_k_lines kle
2440: WHERE kle.id = cleb.id
2441: AND cleb.chr_id = chrid
2442: --ndani - 27-Mar-2013 - Bug# 16552978 - Start