DBA Data[Home] [Help]

APPS.HZ_RELATIONSHIP_V2PUB dependencies on HZ_CONTACT_NUMBERS_S

Line 982: SELECT to_char(hz_contact_numbers_s.nextval)

978: IF p_create_org_contact = 'Y' THEN
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