DBA Data[Home] [Help]

APPS.HZ_PERSON_PROFILES_PKG dependencies on DUAL

Line 265: INTO X_PERSON_PROFILE_ID FROM dual;

261: BEGIN
262: l_count := 1;
263: WHILE l_count > 0 LOOP
264: SELECT HZ_PERSON_PROFILES_S.NEXTVAL
265: INTO X_PERSON_PROFILE_ID FROM dual;
266: BEGIN
267: SELECT 'Y' INTO l_dummy
268: FROM HZ_PERSON_PROFILES
269: WHERE PERSON_PROFILE_ID = X_PERSON_PROFILE_ID;