APPS.HZ_RELATIONSHIP_V2PUB dependencies on DUAL

Line 431: FROM DUAL;

427: WHILE l_dummy = 'Y' LOOP
428: BEGIN
429: SELECT HZ_RELATIONSHIPS_S.NEXTVAL
430: INTO l_relationship_id
431: FROM DUAL;
432:
433: SELECT 'Y'
434: INTO l_dummy
435: FROM HZ_RELATIONSHIPS

Line 983: INTO l_contact_number FROM dual;

979: IF l_contact_number = FND_API.G_MISS_CHAR OR l_contact_number IS NULL THEN
980: l_count := 1;
981: WHILE l_count > 0 LOOP
982: SELECT to_char(hz_contact_numbers_s.nextval)
983: INTO l_contact_number FROM dual;
984:
985: BEGIN
986: SELECT 1
987: INTO l_count