APPS.HZ_EXTRACT_PARTY_SITE_BO_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 72: Contact Preference N Y HZ_CONTACT_PREFERENCES

68:
69: Location Y N HZ_LOCATIONS
70: Party Site Y N HZ_PARTY_SITES
71: Party Site Use N Y HZ_PARTY_SITE_USES
72: Contact Preference N Y HZ_CONTACT_PREFERENCES
73: */
74:
75:
76: PROCEDURE get_party_site_bos(

Line 304: FROM HZ_CONTACT_PREFERENCES CPREF

300: HZ_EXTRACT_BO_UTIL_PVT.GET_USER_NAME(CREATED_BY),
301: CREATION_DATE,
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)