APPS.MSD_DEM_COLLECT_RETURN_HISTORY dependencies on DUAL

Line 556: FROM DUAL;

552: msd_dem_common_utilities.log_debug ('End get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
553:
554: select instr(p_entity_name,':'),length(p_entity_name) --sopjarora
555: INTO l_position,l_length
556: FROM DUAL;
557:
558: IF l_position <> 0 --sopjarora
559: THEN
560: select substr(p_entity_name,1,l_position - 1),substr(p_entity_name,l_position + 1,l_length)

Line 562: FROM DUAL;

558: IF l_position <> 0 --sopjarora
559: THEN
560: select substr(p_entity_name,1,l_position - 1),substr(p_entity_name,l_position + 1,l_length)
561: INTO l_table_name,l_series_name
562: FROM DUAL;
563: ELSE
564: l_table_name := p_entity_name;
565: l_series_name := p_entity_name;
566: END IF;