APPS.INV_LABEL_PVT8 dependencies on HZ_CONTACT_POINTS

Line 1172: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp

1168: CURSOR c_phone_fax(p_location_id NUMBER, p_type VARCHAR2) IS
1169: SELECT hcp.phone_country_code||decode(hcp.phone_country_code, NULL, '',' ')||
1170: decode(hcp.phone_area_code,NULL,'','(')||hcp.phone_area_code||decode(hcp.phone_area_code,NULL,'',')')||
1171: hcp.phone_number customer_site_tel_number
1172: FROM hz_party_sites hps, hz_locations hl, hz_contact_points hcp
1173: WHERE hps.location_id = hl.location_id
1174: AND hcp.owner_table_name = 'HZ_PARTY_SITES'
1175: AND hcp.owner_table_id = hps.party_site_id
1176: AND (((hcp.phone_line_type IN ('PHONE','GEN')) AND (p_type = 'PHONE')) OR