DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_RELATIONSHIPS

Line 7515: HZ_RELATIONSHIPS HR,

7511: HZ_CONTACT_POINTS HCP_EM,
7512: HZ_CONTACT_POINTS HCP_FX,
7513: HZ_CONTACT_POINTS HCP_MB,
7514: -- CSI_LOOKUPS CL,
7515: HZ_RELATIONSHIPS HR,
7516: CSI_I_PARTIES CIPO
7517: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id -- party_id for the contact
7518: AND CIP.PARTY_ID = HR.SUBJECT_ID
7519: AND CIP.CONTACT_IP_ID = CIPO.INSTANCE_PARTY_ID