APPS.HZ_PARTY_INFO_PUB dependencies on DUAL

Line 827: INTO l_credit_rating_id FROM dual;

823: THEN
824: l_count := 1;
825: WHILE l_count > 0 LOOP
826: SELECT hz_credit_ratings_s.nextval
827: INTO l_credit_rating_id FROM dual;
828:
829: SELECT count(*)
830: INTO l_count
831: FROM hz_credit_ratings

Line 1344: INTO l_financial_profile_id FROM dual;

1340:
1341: l_count := 1;
1342: WHILE l_count > 0 LOOP
1343: SELECT hz_financial_profile_s.nextval
1344: INTO l_financial_profile_id FROM dual;
1345:
1346: SELECT count(*)
1347: INTO l_count
1348: FROM hz_financial_profile