APPS.CSF_LOCUS_PUB dependencies on CSF_LF_ROADSEGMENTS

Line 665: FROM csf_lf_roadsegments

661:
662: CURSOR c_geometry IS
663: SELECT /*+ cardinality(l, 1) */
664: roadsegment_geometry
665: FROM csf_lf_roadsegments
666: , TABLE (CAST (p_segment_id_tbl AS jtf_number_table )) l
667: WHERE roadsegment_id = l.COLUMN_VALUE;
668:
669: FUNCTION get_coord(p_tbl_index NUMBER, p_coord_index NUMBER) RETURN NUMBER IS

Line 1034: FROM csf_lf_roadsegments' || l_tbl_sufx || ' r

1030: --Fetch country specific data set to support muti dataset in single instance
1031: select spatial_dataset into l_tbl_sufx from CSF_SPATIAL_CTRY_MAPPINGS where spatial_country_name = p_country or spatial_country_code = p_country;
1032:
1033: l_sql_stmt := 'SELECT /*+ INDEX(r CSF_LF_RDSEGS_N2) */ ROADSEGMENT_ID, SDO_NN_DISTANCE(1) dist
1034: FROM csf_lf_roadsegments' || l_tbl_sufx || ' r
1035: WHERE SDO_NN(r.ROADSEGMENT_GEOMETRY, SDO_GEOMETRY(2002,8307,null,SDO_ELEM_INFO_ARRAY(1,2,1),
1036: SDO_ORDINATE_ARRAY(:1, :2, :3, :4)), ''sdo_num_res=1'', 1) = ''TRUE'' ORDER BY dist';
1037:
1038: OPEN cursor_rdseg for l_sql_stmt USING p_longitude,p_latitude,p_longitude,p_latitude;