APPS.OKL_JTOT_CONTACT_EXTRACT_PVT dependencies on DUAL

Line 471: from dual;

467: If p_id1 is not null and p_id2 is not null and p_name is null then
468: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
469: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
470: into l_where_clause
471: from dual;
472: x_where_clause := l_where_clause;
473: Elsif p_name is not null then
474: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
475: ' NAME like '||''''||p_name||'%'||''''

Line 477: from dual;

473: Elsif p_name is not null then
474: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
475: ' NAME like '||''''||p_name||'%'||''''
476: into l_where_clause
477: from dual;
478: End If;
479: End If;
480: Close jtf_contact_cur;
481: End get_contact;