APPS.WF_PUB_ICC dependencies on DUAL

Line 13: select instr(p_mail_to,':',1) INTO l_sep_index from dual;

9: l_sep_index number;
10: l_receiver varchar2(50);
11: l_name varchar2(50);
12: BEGIN
13: select instr(p_mail_to,':',1) INTO l_sep_index from dual;
14: l_orig_sys:= SubStr(p_mail_to,1,l_sep_index-1);
15: l_name :=SubStr(p_mail_to,l_sep_index+1,length(p_mail_to));
16: if l_orig_sys='PER' then
17: select user_name into l_receiver

Line 169: select instr(l_receiver,':',1) INTO l_sep_index from dual;

165: resultout := wf_engine.eng_completed||':'||wf_no;
166: return;
167: end if;
168:
169: select instr(l_receiver,':',1) INTO l_sep_index from dual;
170:
171: if l_sep_index =0 then
172: --If the seperator does not exist, it mean that no receiver type is specified ,that is incorrect
173: resultout := wf_engine.eng_completed||':'||wf_no;