APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on SDO_GEOMETRY
Line 927: , mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:longitude,:latitude,null),null,null)
923: AND loc.geometry IS NOT NULL
924: AND :longitude IS NOT NULL
925: AND locator_within_distance
926: ( loc.geometry 927: , mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:longitude,:latitude,null),null,null) 928: , ''distance=''
929: || :distance_to_location
930: ||'' units=MILE''
931: ) = ''TRUE''