APPS.OKL_RELEASE_PVT dependencies on OKC_K_REL_OBJS_V

Line 2382: FROM okc_k_rel_objs_v

2378:
2379: CURSOR chk_linked_serv_chr_csr(p_chr_id IN NUMBER)
2380: IS
2381: SELECT 'Y'
2382: FROM okc_k_rel_objs_v
2383: WHERE chr_id = p_chr_id
2384: AND jtot_object1_code = 'OKL_SERVICE'
2385: -- AND rty_code IN ('OKLUBB','OKLSRV')
2386: AND rty_code = 'OKLSRV';

Line 2549: FROM okc_k_rel_objs_v krelobj ,

2545: );
2546:
2547: cursor l_ubb_contract_csr(p_orig_chr_id number) IS
2548: SELECT oks.date_terminated,sts.ste_code
2549: FROM okc_k_rel_objs_v krelobj ,
2550: okc_k_headers_b oks,
2551: okc_statuses_b sts
2552: WHERE krelobj.JTOT_OBJECT1_CODE = 'OKL_SERVICE'
2553: AND krelobj.RTY_CODE = 'OKLUBB'