APPS.OKL_RELEASE_PVT dependencies on OKC_K_REL_OBJS_V

Line 2406: FROM okc_k_rel_objs_v

2402:
2403: CURSOR chk_linked_serv_chr_csr(p_chr_id IN NUMBER)
2404: IS
2405: SELECT 'Y'
2406: FROM okc_k_rel_objs_v
2407: WHERE chr_id = p_chr_id
2408: AND jtot_object1_code = 'OKL_SERVICE'
2409: -- AND rty_code IN ('OKLUBB','OKLSRV')
2410: AND rty_code = 'OKLSRV';

Line 2573: FROM okc_k_rel_objs_v krelobj ,

2569: );
2570:
2571: cursor l_ubb_contract_csr(p_orig_chr_id number) IS
2572: SELECT oks.date_terminated,sts.ste_code
2573: FROM okc_k_rel_objs_v krelobj ,
2574: okc_k_headers_b oks,
2575: okc_statuses_b sts
2576: WHERE krelobj.JTOT_OBJECT1_CODE = 'OKL_SERVICE'
2577: AND krelobj.RTY_CODE = 'OKLUBB'