APPS.CSF_LOCUS_PUB dependencies on CSF_SPATIAL_CTRY_MAPPINGS

Line 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;

1027: x_msg_count := 0;
1028: x_msg_data := 'Success';
1029:
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),