APPS.CSP_PART_SEARCH_PVT dependencies on DUAL

Line 500: select 1 from dual

496: l_geometry mdsys.sdo_geometry;
497: l_point mdsys.sdo_point_type := mdsys.sdo_point_type(-9999,-9999,0);
498: l_test number := 0;
499: cursor c_compare(p_point mdsys.sdo_point_type) is
500: select 1 from dual
501: where l_point <> nvl(p_point,l_point);
502:
503: begin
504: log('technicians','begin');

Line 933: from dual;

929: null arrival_date,
930: null distance,
931: null geometry,
932: 'OPEN'
933: from dual;
934: log('replenishment_source','Inserted records:'||sql%rowcount);
935: end loop;
936: end if;
937: log('replenishment_source','End');

Line 1054: from dual;

1050: l_avail_list_tbl(i).arraival_date,
1051: null,
1052: 'OPEN',
1053: null
1054: from dual;
1055: log('atp','Inserted records:'||sql%rowcount);
1056: end loop;
1057: log('atp','End');
1058: end;

Line 2145: FROM dual;

2141: log('get_src_distance','l_distance_uom:'||l_distance_uom);
2142:
2143: SELECT ROUND(sdo_geom.sdo_distance(l_src_geo, l_dest_geo, 1000, l_distance_uom),1)
2144: INTO l_distance
2145: FROM dual;
2146: log('get_src_distance','l_distance:'||l_distance);
2147:
2148: if l_distance <> '-' then
2149: SELECT meaning