APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_CONTACT_POINTS

Line 7558: HZ_CONTACT_POINTS HCP_WP,

7554: FROM
7555: HZ_PARTIES HP,
7556: CSI_I_PARTIES CIP,
7557: -- CSI_IPA_RELATION_TYPES CIR,
7558: HZ_CONTACT_POINTS HCP_WP,
7559: HZ_CONTACT_POINTS HCP_HP,
7560: HZ_CONTACT_POINTS HCP_PG,
7561: HZ_CONTACT_POINTS HCP_EM,
7562: HZ_CONTACT_POINTS HCP_FX,

Line 7559: HZ_CONTACT_POINTS HCP_HP,

7555: HZ_PARTIES HP,
7556: CSI_I_PARTIES CIP,
7557: -- CSI_IPA_RELATION_TYPES CIR,
7558: HZ_CONTACT_POINTS HCP_WP,
7559: HZ_CONTACT_POINTS HCP_HP,
7560: HZ_CONTACT_POINTS HCP_PG,
7561: HZ_CONTACT_POINTS HCP_EM,
7562: HZ_CONTACT_POINTS HCP_FX,
7563: HZ_CONTACT_POINTS HCP_MB,

Line 7560: HZ_CONTACT_POINTS HCP_PG,

7556: CSI_I_PARTIES CIP,
7557: -- CSI_IPA_RELATION_TYPES CIR,
7558: HZ_CONTACT_POINTS HCP_WP,
7559: HZ_CONTACT_POINTS HCP_HP,
7560: HZ_CONTACT_POINTS HCP_PG,
7561: HZ_CONTACT_POINTS HCP_EM,
7562: HZ_CONTACT_POINTS HCP_FX,
7563: HZ_CONTACT_POINTS HCP_MB,
7564: -- CSI_LOOKUPS CL,

Line 7561: HZ_CONTACT_POINTS HCP_EM,

7557: -- CSI_IPA_RELATION_TYPES CIR,
7558: HZ_CONTACT_POINTS HCP_WP,
7559: HZ_CONTACT_POINTS HCP_HP,
7560: HZ_CONTACT_POINTS HCP_PG,
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,

Line 7562: HZ_CONTACT_POINTS HCP_FX,

7558: HZ_CONTACT_POINTS HCP_WP,
7559: HZ_CONTACT_POINTS HCP_HP,
7560: HZ_CONTACT_POINTS HCP_PG,
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

Line 7563: HZ_CONTACT_POINTS HCP_MB,

7559: HZ_CONTACT_POINTS HCP_HP,
7560: HZ_CONTACT_POINTS HCP_PG,
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