APPS.OKS_ENTITLEMENTS_PVT dependencies on OKS_COV_TYPES_V

Line 6213: ,OKS_Cov_Types_V CVT

6209: ,CVT.Meaning
6210: ,CVT.Description
6211: ,CVT.Importance_Level
6212: FROM OKS_K_Lines_B OKSLB
6213: ,OKS_Cov_Types_V CVT
6214: WHERE OKSLB.Cle_Id = Cx_CVL_Id
6215: AND OKSLB.Coverage_Type = CVT.Code;
6216:
6217: Lx_CVL_Id CONSTANT Gx_OKS_Id := P_CVL_Id;

Line 13017: from oks_cov_types_v

13013: IS
13014:
13015: CURSOR Cur_ImplvlExists is
13016: select count(*) cnt
13017: from oks_cov_types_v
13018: where importance_level is NOT NULL;
13019: --
13020: --
13021: -- Modified for 12.0 Coverage Rearch project (JVARGHES)

Line 13040: -- oks_cov_types_v cvt

13036: -- oks_k_lines_b okscle_cov,
13037: -- okc_k_lines_b cle_cvl,
13038: -- okc_k_items cim,
13039: -- okc_statuses_v sts,
13040: -- oks_cov_types_v cvt
13041: -- where cle.chr_id = okh.id
13042: -- and okh.sts_code = sts.code
13043: -- and sts.ste_code = 'ACTIVE'
13044: -- and cle_cov.cle_id = cle.id

Line 13073: oks_cov_types_v cvt

13069: oks_k_lines_b okscle_cov,
13070: okc_k_lines_b cle_cvl,
13071: okc_k_items cim,
13072: okc_statuses_v sts,
13073: oks_cov_types_v cvt
13074: where cle.chr_id = okh.id
13075: and okh.sts_code = sts.code
13076: and sts.ste_code = 'ACTIVE'
13077: and cle_ksl.cle_id = cle.id

Line 13106: -- oks_cov_types_v covtyp

13102: -- oks_k_lines_b okscle_cov,
13103: -- okc_k_lines_b cle_cvl,
13104: -- okc_k_items cim,
13105: -- okc_statuses_v sts,
13106: -- oks_cov_types_v covtyp
13107: -- where cle.chr_id = okh.id
13108: -- and okh.sts_code = sts.code
13109: -- and sts.ste_code = 'ACTIVE'
13110: -- and cle_cov.cle_id = cle.id

Line 13141: oks_cov_types_v covtyp

13137: oks_k_lines_b okscle_cov,
13138: okc_k_lines_b cle_cvl,
13139: okc_k_items cim,
13140: okc_statuses_v sts,
13141: oks_cov_types_v covtyp
13142: where cle.chr_id = okh.id
13143: and okh.sts_code = sts.code
13144: and sts.ste_code = 'ACTIVE'
13145: and cle_ksl.cle_id = cle.id