APPS.CLN_RN_UTILS dependencies on HZ_PARTIES

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 439: FROM hz_parties hz

435: WHERE location_id = l_party_id;
436: ELSIF (l_party_type = 'C') or (l_party_type = 'CARRIER') THEN
437: SELECT hz.party_name
438: INTO x_name
439: FROM hz_parties hz
440: WHERE hz.party_id = l_party_id;
441: BEGIN
442: Select phone_number, email_address
443: Into x_telephone, x_email

Line 445: Where owner_table_name = 'HZ_PARTIES'

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
449: WHEN NO_DATA_FOUND THEN