APPS.OKS_ENTITLEMENTS_PVT dependencies on OKX_PARTIES_V

Line 8096: FROM Okx_Parties_V PY

8092: IS
8093:
8094: CURSOR Lx_Csr_CovParty(Cx_CovParty_Id IN Gx_OKS_Id ) IS
8095: SELECT '*'
8096: FROM Okx_Parties_V PY
8097: WHERE PY.Id1 = Cx_CovParty_Id
8098: AND PY.Id2 = '#';
8099:
8100: Lx_CovParty_Obj_Id CONSTANT Gx_OKS_Id := P_CovParty_Obj_Id;

Line 13639: FROM Okx_Parties_V PX

13635: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
13636: AND (Cv_Con_Cusomer_Id IS NULL
13637: OR
13638: HB.Id IN ( SELECT PR.Chr_Id
13639: FROM Okx_Parties_V PX
13640: ,Okc_K_Party_Roles_B PR
13641: WHERE PR.Object1_Id1 = NVL(Cv_Con_Cusomer_Id,PR.Object1_Id1) --PR.Chr_Id = HB.Id
13642: AND PR.Rle_Code in ('CUSTOMER')
13643: AND PR.Jtot_Object1_Code = 'OKX_PARTY'

Line 13686: FROM Okx_Parties_V PX

13682: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
13683: AND (Cv_Con_Cusomer_Id IS NULL
13684: OR
13685: HB.Id IN ( SELECT PR.Chr_Id
13686: FROM Okx_Parties_V PX
13687: ,Okc_K_Party_Roles_B PR
13688: WHERE PR.Object1_Id1 = NVL(Cv_Con_Cusomer_Id,PR.Object1_Id1) --PR.Chr_Id = HB.Id
13689: AND PR.Rle_Code in ('CUSTOMER','SUBSCRIBER') ---Modified condition for ER9681794
13690: AND PR.Jtot_Object1_Code = 'OKX_PARTY'