APPS.IRC_UTILITIES_PKG dependencies on SDO_GEOMETRY

Line 1738: ' ,mdsys.sdo_geometry (2001 '||

1734: 'WHERE ilp.object_id = pav.vacancy_id '||
1735: 'AND ilp.object_type = ''VACANCY'' '||
1736: 'AND loc1.location_id = ilp.location_id '||
1737: 'AND locator_within_distance (loc1.geometry '||
1738: ' ,mdsys.sdo_geometry (2001 '||
1739: ',8307 '||
1740: ' ,mdsys.sdo_point_type ('||l_long||
1741: ','||l_lat||
1742: ',NULL) '||

Line 1754: ',mdsys.sdo_geometry (2001 '||

1750: 'SELECT NULL '||
1751: 'FROM hr_locations_all loc2 '||
1752: 'WHERE loc2.location_id = pav.location_id '||
1753: 'AND locator_within_distance (loc2.geometry '||
1754: ',mdsys.sdo_geometry (2001 '||
1755: ',8307 '||
1756: ',mdsys.sdo_point_type ('||l_long||
1757: ','||l_lat||
1758: ',NULL) '||