APPS.HZ_CONTACT_PREFERENCE_VALIDATE dependencies on FND_LOOKUP_VALUES

Line 181: l_tag FND_LOOKUP_VALUES.tag%TYPE;

177: l_contact_point_type HZ_CONTACT_POINTS.contact_point_type%TYPE;
178: l_created_by_module HZ_CONTACT_PREFERENCES.created_by_module%TYPE;
179: l_application_id NUMBER;
180: l_dummy VARCHAR2(1);
181: l_tag FND_LOOKUP_VALUES.tag%TYPE;
182: l_time_comparison VARCHAR2(30) := FND_API.G_TRUE;
183: l_correct_contact_type VARCHAR2(30);
184: l_contact_preference_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
185: l_preference_topic_type HZ_CONTACT_PREFERENCES.preference_topic_type%TYPE;

Line 584: FROM FND_LOOKUP_VALUES

580:
581:
582: SELECT TAG
583: INTO l_tag
584: FROM FND_LOOKUP_VALUES
585: WHERE
586: LANGUAGE = userenv('LANG') AND
587: START_DATE_ACTIVE < sysdate AND
588: ( END_DATE_ACTIVE is null OR