APPS.WSH_MAPPING_DATA dependencies on HZ_CONTACT_POINTS

Line 658: hz_contact_points hcp,

654: CURSOR phone_fax_cur(l_line_type VARCHAR2) IS
655: SELECT hcp.raw_phone_number,
656: hcp.url
657: FROM hz_party_sites hps,
658: hz_contact_points hcp,
659: wsh_locations_hz_v wlhz
660: WHERE HCP.CONTACT_POINT_TYPE = 'PHONE'
661: AND HCP.PHONE_LINE_TYPE=l_line_type
662: AND HCP.OWNER_TABLE_NAME = 'HZ_PARTY_SITES'

Line 1212: HZ_CONTACT_POINTS PHONE_CONTACT,

1208: HREL.PARTY_ID
1209: from HZ_CUST_ACCOUNT_ROLES HCAR,
1210: HZ_RELATIONSHIPS HREL,
1211: HZ_ORG_CONTACTS HOC,
1212: HZ_CONTACT_POINTS PHONE_CONTACT,
1213: HZ_PARTIES PER_CONTACT
1214: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
1215: AND HREL.PARTY_ID = HCAR.PARTY_ID
1216: AND HCAR.ROLE_TYPE = 'CONTACT'

Line 1231: FROM HZ_CONTACT_POINTS

1227: AND PHONE_CONTACT.PRIMARY_FLAG(+) = 'Y';
1228:
1229: cursor l_ship_to_site_ph_csr(p_owner_tbl_id IN NUMBER) is
1230: SELECT RAW_PHONE_NUMBER
1231: FROM HZ_CONTACT_POINTS
1232: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
1233: AND OWNER_TABLE_ID = p_owner_tbl_id
1234: AND CONTACT_POINT_TYPE = 'PHONE'
1235: AND PHONE_LINE_TYPE = 'GEN';