APPS.CSF_TDS_PUB dependencies on DUAL

Line 147: -- FROM dual;

143:
144: -- SELECT NVL( TO_NUMBER(fnd_profile.value('CSR_MAX_TRAVEL_DIST_FOR_ESTIMATION')) ,100)
145: -- ,NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
146: -- INTO threshhold, multiDataSetProfileValue
147: -- FROM dual;
148: -- Commented for bug 8289413
149:
150: SELECT NVL( TO_NUMBER(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxDistToSkipActual')) ,100)
151: ,NVL(fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED'),'N')

Line 153: FROM dual;

149:
150: SELECT NVL( TO_NUMBER(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxDistToSkipActual')) ,100)
151: ,NVL(fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED'),'N')
152: INTO threshhold, multiDataSetProfileEnabled
153: FROM dual;
154:
155: IF UPPER(multiDataSetProfileEnabled) = 'N' OR multiDataSetProfileEnabled IS NULL
156: THEN
157: select '' SPATIAL_DATASET bulk collect into mdsList from dual;

Line 157: select '' SPATIAL_DATASET bulk collect into mdsList from dual;

153: FROM dual;
154:
155: IF UPPER(multiDataSetProfileEnabled) = 'N' OR multiDataSetProfileEnabled IS NULL
156: THEN
157: select '' SPATIAL_DATASET bulk collect into mdsList from dual;
158: ELSIF UPPER(multiDataSetProfileEnabled) = 'Y'
159: THEN
160: select distinct SPATIAL_DATASET bulk collect into mdsList from csf_spatial_ctry_mappings;
161: END IF;

Line 421: FROM dual;

417: BEGIN
418:
419: SELECT NVL(fnd_profile.value('CSF_SPATIAL_DATASET_NAME'),'')
420: INTO multiDataSetProfileValue
421: FROM dual;
422:
423: IF UPPER(multiDataSetProfileValue) = 'NONE'
424: THEN
425: multiDataSetProfileValue :='';