DBA Data[Home] [Help]

APPS.HZ_EMPLOYMENT_HISTORY_PKG dependencies on DUAL

Line 136: INTO X_EMPLOYMENT_HISTORY_ID FROM dual;

132: BEGIN
133: l_count := 1;
134: WHILE l_count > 0 LOOP
135: SELECT HZ_EMPLOYMENT_HISTORY_S.NEXTVAL
136: INTO X_EMPLOYMENT_HISTORY_ID FROM dual;
137: BEGIN
138: SELECT 'Y' INTO l_dummy
139: FROM HZ_EMPLOYMENT_HISTORY
140: WHERE EMPLOYMENT_HISTORY_ID = EMPLOYMENT_HISTORY_ID;