556: BEGIN
557: l_count := 1;
558: WHILE l_count > 0 LOOP
559: SELECT HZ_CREDIT_RATINGS_S.NEXTVAL
560: INTO x_credit_rating_id FROM dual;
561: BEGIN
562: SELECT 'Y' INTO l_dummy
563: FROM HZ_CREDIT_RATINGS
564: WHERE credit_rating_id = x_credit_rating_id;