7504: FROM
7505: HZ_PARTIES HP,
7506: CSI_I_PARTIES CIP,
7507: -- CSI_IPA_RELATION_TYPES CIR,
7508: HZ_CONTACT_POINTS HCP_WP,
7509: HZ_CONTACT_POINTS HCP_HP,
7510: HZ_CONTACT_POINTS HCP_PG,
7511: HZ_CONTACT_POINTS HCP_EM,
7512: HZ_CONTACT_POINTS HCP_FX,
7505: HZ_PARTIES HP,
7506: CSI_I_PARTIES CIP,
7507: -- CSI_IPA_RELATION_TYPES CIR,
7508: HZ_CONTACT_POINTS HCP_WP,
7509: HZ_CONTACT_POINTS HCP_HP,
7510: HZ_CONTACT_POINTS HCP_PG,
7511: HZ_CONTACT_POINTS HCP_EM,
7512: HZ_CONTACT_POINTS HCP_FX,
7513: HZ_CONTACT_POINTS HCP_MB,
7506: CSI_I_PARTIES CIP,
7507: -- CSI_IPA_RELATION_TYPES CIR,
7508: HZ_CONTACT_POINTS HCP_WP,
7509: HZ_CONTACT_POINTS HCP_HP,
7510: HZ_CONTACT_POINTS HCP_PG,
7511: HZ_CONTACT_POINTS HCP_EM,
7512: HZ_CONTACT_POINTS HCP_FX,
7513: HZ_CONTACT_POINTS HCP_MB,
7514: -- CSI_LOOKUPS CL,
7507: -- CSI_IPA_RELATION_TYPES CIR,
7508: HZ_CONTACT_POINTS HCP_WP,
7509: HZ_CONTACT_POINTS HCP_HP,
7510: HZ_CONTACT_POINTS HCP_PG,
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,
7508: HZ_CONTACT_POINTS HCP_WP,
7509: HZ_CONTACT_POINTS HCP_HP,
7510: HZ_CONTACT_POINTS HCP_PG,
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
7509: HZ_CONTACT_POINTS HCP_HP,
7510: HZ_CONTACT_POINTS HCP_PG,
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