APPS.PAY_IN_24Q_ER_RETURNS dependencies on DUAL

Line 990: FROM dual;

986: IF (l_phone <>'^') THEN
987: SELECT SUBSTR (l_phone,INSTR(l_phone,'-',1,1)+1,INSTR(l_phone,'-',1,2)-INSTR (l_phone,'-',1,1)-1) STD
988: ,SUBSTR (l_phone,INSTR(l_phone,'-',1,2)+1) TELPH
989: INTO l_std,l_telph
990: FROM dual;
991: l_std :=SUBSTR(l_std,1,5)||'^';
992: l_telph := SUBSTR(l_telph,1,10)||'^';
993: END IF;
994: