APPS.MSD_DEM_COLLECT_RETURN_HISTORY dependencies on DUAL

Line 568: FROM DUAL;

564: msd_dem_common_utilities.log_debug ('End get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
565:
566: select instr(p_entity_name,':'),length(p_entity_name) --sopjarora
567: INTO l_position,l_length
568: FROM DUAL;
569:
570: IF l_position <> 0 --sopjarora
571: THEN
572: select substr(p_entity_name,1,l_position - 1),substr(p_entity_name,l_position + 1,l_length)

Line 574: FROM DUAL;

570: IF l_position <> 0 --sopjarora
571: THEN
572: select substr(p_entity_name,1,l_position - 1),substr(p_entity_name,l_position + 1,l_length)
573: INTO l_table_name,l_series_name
574: FROM DUAL;
575: ELSE
576: l_table_name := p_entity_name;
577: l_series_name := p_entity_name;
578: END IF;