APPS.RRS_SITE_UTILS dependencies on DUAL

Line 267: from dual;

263: ELSIF(p_context_flag = 'IDENTIFY' OR p_context_flag = 'POINT_FEATURE' OR p_context_flag = 'POINT_FEATURE_AT_LOCATION') THEN
264:
265: select SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(p_x_coord,p_y_coord,null),null,null)
266: into l_geometry
267: from dual;
268:
269: IF(p_context_flag = 'IDENTIFY') THEN
270: insert into RRS_SITE_TMP
271: (session_id,theme_id,geometry)

Line 733: FROM DUAL;

729: FETCH ebi_cursor INTO l_site_name,l_row_id;
730: -- l_default_seq_num := RRS_DEFAULT_SITE_NUMBER_S.NEXTVAL;
731: SELECT RRS_DEFAULT_SITE_NUMBER_S.NEXTVAL
732: INTO l_default_seq_num
733: FROM DUAL;
734:
735: EXIT WHEN ebi_cursor%NOTFOUND;
736: --Start Bug#9455517 Fix
737: --Check whether Result usage Format contains Multi Row Attribute Group