DBA Data[Home] [Help]

APPS.ARH_PHON_PKG dependencies on DUAL

Line 401: FROM dual;

397:
398: while l_count > 0 loop
399: SELECT hz_contact_points_s.nextval
400: INTO x_phone_id
401: FROM dual;
402:
403: select count(*) into l_count from hz_contact_points
404: where contact_point_id = x_phone_id ;
405:

Line 410: from dual;

406: END LOOP;
407: --
408: SELECT hz_cust_contact_points_s.nextval
409: into x_cust_contact_point_id
410: from dual;
411: --
412: IF ( x_orig_system_reference is null)
413: THEN
414: x_orig_system_reference := x_phone_id;