APPS.PV_LOCATOR dependencies on HZ_CONTACT_POINTS

Line 91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,

87: STATE HZ_LOCATIONS.STATE%TYPE,
88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,
91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,
92: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE,
93: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE,
94: row_number NUMBER
95: );

Line 92: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE,

88: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,
91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,
92: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE,
93: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE,
94: row_number NUMBER
95: );
96:

Line 93: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE,

89: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
90: PARTNER_URL HZ_PARTIES.URL%TYPE,
91: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE,
92: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE,
93: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE,
94: row_number NUMBER
95: );
96:
97: l_partner_rec l_partner_rec_type;

Line 130: hz_contact_points cp,

126: ) tmp,
127: hz_parties org,
128: hz_party_sites hzs,
129: hz_locations hzl,
130: hz_contact_points cp,
131: pv_partner_profiles pvpp
132: where tmp.party_id = pvpp.partner_id
133: and org.party_id = pvpp.partner_party_id
134: and org.party_type = 'ORGANIZATION'