APPS.HZ_UTILITY_V2PUB dependencies on HZ_CONTACT_PREFERENCES
Line 2755: FROM hz_contact_preferences
2751: ) RETURN VARCHAR2 IS
2752:
2753: CURSOR c_restriction IS
2754: SELECT null 2755: FROM hz_contact_preferences 2756: WHERE contact_level_table = p_contact_level_table
2757: AND contact_level_table_id = p_contact_level_table_id
2758: AND preference_code = p_preference_code
2759: AND status = 'A'