APPS.HZ_CITIZENSHIP_PKG dependencies on DUAL

Line 97: INTO X_CITIZENSHIP_ID FROM dual;

93: BEGIN
94: l_count := 1;
95: WHILE l_count > 0 LOOP
96: SELECT HZ_CITIZENSHIP_S.NEXTVAL
97: INTO X_CITIZENSHIP_ID FROM dual;
98: BEGIN
99: SELECT 'Y' INTO l_dummy
100: FROM HZ_CITIZENSHIP
101: WHERE CITIZENSHIP_ID = CITIZENSHIP_ID;