DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKX_PARTIES_V

Line 7708: FROM Okx_Parties_V PY

7704: IS
7705:
7706: CURSOR Lx_Csr_CovParty(Cx_CovParty_Id IN Gx_OKS_Id ) IS
7707: SELECT '*'
7708: FROM Okx_Parties_V PY
7709: WHERE PY.Id1 = Cx_CovParty_Id
7710: AND PY.Id2 = '#';
7711:
7712: Lx_CovParty_Obj_Id CONSTANT Gx_OKS_Id := P_CovParty_Obj_Id;

Line 12388: FROM Okx_Parties_V PX

12384: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
12385: AND (Cv_Con_Cusomer_Id IS NULL
12386: OR
12387: HB.Id IN ( SELECT PR.Chr_Id
12388: FROM Okx_Parties_V PX
12389: ,Okc_K_Party_Roles_B PR
12390: WHERE PR.Object1_Id1 = NVL(Cv_Con_Cusomer_Id,PR.Object1_Id1) --PR.Chr_Id = HB.Id
12391: AND PR.Rle_Code = 'CUSTOMER'
12392: AND PR.Jtot_Object1_Code = 'OKX_PARTY'