DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_RELATIONSHIPS

Line 7565: HZ_RELATIONSHIPS HR,

7561: HZ_CONTACT_POINTS HCP_EM,
7562: HZ_CONTACT_POINTS HCP_FX,
7563: HZ_CONTACT_POINTS HCP_MB,
7564: -- CSI_LOOKUPS CL,
7565: HZ_RELATIONSHIPS HR,
7566: CSI_I_PARTIES CIPO
7567: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id -- party_id for the contact
7568: AND CIP.PARTY_ID = HR.SUBJECT_ID
7569: AND CIP.CONTACT_IP_ID = CIPO.INSTANCE_PARTY_ID