DBA Data[Home] [Help]

APPS.CSF_LF_PUB dependencies on CSF_SPATIAL_CTRY_MAPPINGS

Line 153: FROM CSF_SPATIAL_CTRY_MAPPINGS

149: */
150: l_country VARCHAR2(100);
151: CURSOR ctry_hr_to_spatial IS
152: SELECT SPATIAL_COUNTRY_NAME
153: FROM CSF_SPATIAL_CTRY_MAPPINGS
154: WHERE HR_COUNTRY_NAME = p_country;
155: BEGIN
156:
157: IF l_debug THEN

Line 315: sql_stmt_str := 'select spatial_dataset from csf_spatial_ctry_mappings

311: l_data_set_name := '';
312: ELSE
313: BEGIN
314: l_data_set_name := '';
315: sql_stmt_str := 'select spatial_dataset from csf_spatial_ctry_mappings
316: WHERE spatial_country_name = ''' || upper(l_country)|| '''';
317: OPEN ref_cur FOR sql_stmt_str;
318: FETCH ref_cur INTO l_data_set_name;
319: CLOSE ref_cur;