DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on DUAL

Line 1025: FROM dual;

1021: IF (l_phone <>'^') THEN
1022: SELECT SUBSTR (l_phone,INSTR(l_phone,'-',1,1)+1,INSTR(l_phone,'-',1,2)-INSTR (l_phone,'-',1,1)-1) STD
1023: ,SUBSTR (l_phone,INSTR(l_phone,'-',1,2)+1) TELPH
1024: INTO l_std,l_telph
1025: FROM dual;
1026: l_std :=SUBSTR(l_std,1,5)||'^';
1027: l_telph := SUBSTR(l_telph,1,10)||'^';
1028: END IF;
1029: