95: BEGIN
96: l_count := 1;
97: WHILE l_count > 0 LOOP
98: SELECT HZ_PERSON_INTEREST_S.NEXTVAL 99: INTO X_PERSON_INTEREST_ID FROM dual; 100: BEGIN
101: SELECT 'Y' INTO l_dummy
102: FROM HZ_PERSON_INTEREST
103: WHERE PERSON_INTEREST_ID = X_PERSON_INTEREST_ID;