APPS.CLN_RN_UTILS dependencies on HZ_CONTACT_POINTS

Line 427: FROM CE_BANK_BRANCHES_V bb, HZ_PARTIES hp, HZ_contact_points hcp

423: AND pvsa.vendor_site_id = l_party_site_id;
424: ELSIF (l_party_type = 'B') THEN
425: SELECT BANK_BRANCH_NAME,hcp.RAW_PHONE_NUMBER,hcp.EDI_ECE_TP_LOCATION_CODE
426: INTO x_name, x_telephone, x_ece_location_code
427: FROM CE_BANK_BRANCHES_V bb, HZ_PARTIES hp, HZ_contact_points hcp
428: WHERE bb.BRANCH_PARTY_ID = l_party_id
429: AND bb.BRANCH_PARTY_ID = hp.party_id
430: AND hp.PRIMARY_PHONE_CONTACT_PT_ID = hcp.CONTACT_POINT_ID;
431: ELSIF (l_party_type = 'I') THEN

Line 444: From hz_contact_points

440: WHERE hz.party_id = l_party_id;
441: BEGIN
442: Select phone_number, email_address
443: Into x_telephone, x_email
444: From hz_contact_points
445: Where owner_table_name = 'HZ_PARTIES'
446: and owner_table_id = l_party_id
447: and rownum < 1;
448: EXCEPTION