APPS.CSF_TASK_ADDRESS_PVT dependencies on CSF_SPATIAL_CTRY_MAPPINGS

Line 734: csf_spatial_ctry_mappings cm

730: hz_locations l,
731: fnd_territories_tl tl,
732: jtf_task_statuses_vl jts,
733: csf_sdm_ctry_profiles' || p_dataset || ' cp,
734: csf_spatial_ctry_mappings cm
735: WHERE tt.task_type_id = t.task_type_id
736: AND t.location_id is not null
737: AND l.location_id = t.location_id
738: AND tl.territory_code = l.country

Line 778: csf_spatial_ctry_mappings cm

774: hz_locations l,
775: fnd_territories_tl tl,
776: jtf_task_statuses_vl jts,
777: csf_sdm_ctry_profiles' || p_dataset || ' cp,
778: csf_spatial_ctry_mappings cm
779: WHERE tt.task_type_id = t.task_type_id
780: AND t.address_id is not null
781: AND t.address_id = hps.party_site_id
782: AND l.location_id = hps.location_id

Line 944: select distinct spatial_dataset from csf_spatial_ctry_mappings;

940: l_mds_enabled varchar2(10);
941: l_geo_coder_url varchar2(250);
942:
943: cursor mdsListCur is
944: select distinct spatial_dataset from csf_spatial_ctry_mappings;
945:
946: BEGIN
947: -- Standard check for call compatibility
948: IF NOT fnd_api.compatible_api_call (l_api_version,

Line 972: --If Multi dataset, select tasks which belongs to datasets listed in csf_spatial_ctry_mappings

968:
969: l_mds_enabled:= fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
970: l_geo_coder_url:= fnd_profile.value('CSF_GEOSPATIAL_SERVICE_URL');
971: --If Single dataset, select tasks which belongs to that dataset
972: --If Multi dataset, select tasks which belongs to datasets listed in csf_spatial_ctry_mappings
973: if( l_mds_enabled = 'N' or l_mds_enabled is null or l_geo_coder_url is not null)
974: then
975: form_task_address_query('',
976: p_start_date,

Line 1279: FROM CSF_SPATIAL_CTRY_MAPPINGS

1275:
1276: l_country VARCHAR2(100);
1277: CURSOR ctry_hr_to_spatial IS
1278: SELECT SPATIAL_COUNTRY_NAME,spatial_dataset
1279: FROM CSF_SPATIAL_CTRY_MAPPINGS
1280: WHERE HR_COUNTRY_NAME = p_task_rec.country;
1281:
1282: BEGIN
1283: -- Standard check for call compatibility

Line 1981: FROM CSF_SPATIAL_CTRY_MAPPINGS

1977: l_spatial_dataset VARCHAR2(10);
1978: l_country VARCHAR2(100);
1979: CURSOR ctry_hr_to_spatial IS
1980: SELECT SPATIAL_COUNTRY_NAME, spatial_dataset
1981: FROM CSF_SPATIAL_CTRY_MAPPINGS
1982: WHERE HR_COUNTRY_NAME = upper(p_country);
1983:
1984:
1985: BEGIN

Line 3006: sql_stmt_str := 'select spatial_dataset from csf_spatial_ctry_mappings

3002: l_data_set_name := '';
3003: ELSE
3004: BEGIN
3005: l_data_set_name := '';
3006: sql_stmt_str := 'select spatial_dataset from csf_spatial_ctry_mappings
3007: WHERE spatial_country_name = ''' || upper(p_country)|| '''';
3008: OPEN ref_cur FOR sql_stmt_str;
3009: FETCH ref_cur INTO l_data_set_name;
3010: CLOSE ref_cur;

Line 3159: sql_stmt_str := 'select spatial_dataset from csf_spatial_ctry_mappings

3155: l_data_set_name := '';
3156: ELSE
3157: BEGIN
3158: l_data_set_name := '';
3159: sql_stmt_str := 'select spatial_dataset from csf_spatial_ctry_mappings
3160: WHERE spatial_country_name = ''' || upper(p_country)|| '''';
3161: OPEN ref_cur FOR sql_stmt_str;
3162: FETCH ref_cur INTO l_data_set_name;
3163: CLOSE ref_cur;