APPS.OKS_ENTITLEMENTS_PVT dependencies on OKS_COV_TYPES_V

Line 6601: ,OKS_Cov_Types_V CVT

6597: ,CVT.Meaning
6598: ,CVT.Description
6599: ,CVT.Importance_Level
6600: FROM OKS_K_Lines_B OKSLB
6601: ,OKS_Cov_Types_V CVT
6602: WHERE OKSLB.Cle_Id = Cx_CVL_Id
6603: AND OKSLB.Coverage_Type = CVT.Code;
6604:
6605: Lx_CVL_Id CONSTANT Gx_OKS_Id := P_CVL_Id;

Line 14375: from oks_cov_types_v

14371: IS
14372:
14373: CURSOR Cur_ImplvlExists is
14374: select count(*) cnt
14375: from oks_cov_types_v
14376: where importance_level is NOT NULL;
14377: --
14378: --
14379: -- Modified for 12.0 Coverage Rearch project (JVARGHES)

Line 14398: -- oks_cov_types_v cvt

14394: -- oks_k_lines_b okscle_cov,
14395: -- okc_k_lines_b cle_cvl,
14396: -- okc_k_items cim,
14397: -- okc_statuses_v sts,
14398: -- oks_cov_types_v cvt
14399: -- where cle.chr_id = okh.id
14400: -- and okh.sts_code = sts.code
14401: -- and sts.ste_code = 'ACTIVE'
14402: -- and cle_cov.cle_id = cle.id

Line 14431: oks_cov_types_v cvt

14427: oks_k_lines_b okscle_cov,
14428: okc_k_lines_b cle_cvl,
14429: okc_k_items cim,
14430: okc_statuses_v sts,
14431: oks_cov_types_v cvt
14432: where cle.chr_id = okh.id
14433: and okh.sts_code = sts.code
14434: and sts.ste_code = 'ACTIVE'
14435: and cle_ksl.cle_id = cle.id

Line 14464: -- oks_cov_types_v covtyp

14460: -- oks_k_lines_b okscle_cov,
14461: -- okc_k_lines_b cle_cvl,
14462: -- okc_k_items cim,
14463: -- okc_statuses_v sts,
14464: -- oks_cov_types_v covtyp
14465: -- where cle.chr_id = okh.id
14466: -- and okh.sts_code = sts.code
14467: -- and sts.ste_code = 'ACTIVE'
14468: -- and cle_cov.cle_id = cle.id

Line 14499: oks_cov_types_v covtyp

14495: oks_k_lines_b okscle_cov,
14496: okc_k_lines_b cle_cvl,
14497: okc_k_items cim,
14498: okc_statuses_v sts,
14499: oks_cov_types_v covtyp
14500: where cle.chr_id = okh.id
14501: and okh.sts_code = sts.code
14502: and sts.ste_code = 'ACTIVE'
14503: and cle_ksl.cle_id = cle.id