APPS.HZ_CONTACT_PREFERENCES_PKG dependencies on DUAL
Line 121: INTO X_CONTACT_PREFERENCE_ID FROM dual;
117: BEGIN
118: l_count := 1;
119: WHILE l_count > 0 LOOP
120: SELECT HZ_CONTACT_PREFERENCES_S.NEXTVAL 121: INTO X_CONTACT_PREFERENCE_ID FROM dual; 122: BEGIN
123: SELECT 'Y' INTO l_dummy
124: FROM HZ_CONTACT_PREFERENCES
125: WHERE CONTACT_PREFERENCE_ID = X_CONTACT_PREFERENCE_ID;