272: HZ_TELEX_CP_BO_TBL(),
273: HZ_EMAIL_CP_BO_TBL(),
274: HZ_WEB_CP_BO_TBL(),
275: CAST(MULTISET (
276: SELECT HZ_CONTACT_PREF_OBJ(
277: P_ACTION_TYPE,
278: NULL, -- COMMON_OBJ_ID
279: CONTACT_PREFERENCE_ID,
280: 'PARTY_SITE',
302: LAST_UPDATE_DATE,
303: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(LAST_UPDATED_BY))
304: FROM HZ_CONTACT_PREFERENCES CPREF
305: WHERE CONTACT_LEVEL_TABLE = 'HZ_PARTY_SITES'
306: AND CONTACT_LEVEL_TABLE_ID = PS.PARTY_SITE_ID) AS HZ_CONTACT_PREF_OBJ_TBL))
307: FROM HZ_PARTY_SITES PS, HZ_LOCATIONS LOC WHERE PS.LOCATION_ID = LOC.LOCATION_ID
308: AND ((P_PARTY_SITE_ID IS NULL AND PARTY_ID = P_PARTY_ID)
309: OR (P_PARTY_SITE_ID IS NOT NULL AND PARTY_SITE_ID = P_PARTY_SITE_ID));
310: