434: WHILE l_dummy = 'Y' LOOP
435: BEGIN
436: SELECT HZ_RELATIONSHIPS_S.NEXTVAL
437: INTO l_relationship_id
438: FROM DUAL;
439:
440: SELECT 'Y'
441: INTO l_dummy
442: FROM HZ_RELATIONSHIPS