APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on DUAL

Line 368: from dual;

364: If ( p_name is not null and p_name <> OKC_API.G_MISS_CHAR) then
365: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
366: ' DESCRIPTION like :name'
367: into l_where_clause
368: from dual;
369: x_where_clause := l_where_clause;
370: End If;
371:
372: If p_id1 is not null and p_id1 <> OKC_API.G_MISS_CHAR

Line 377: from dual;

373: and p_id2 is not null and p_id2 <> OKC_API.G_MISS_CHAR then
374: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
375: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
376: into l_where_clause
377: from dual;
378: x_where_clause := l_where_clause;
379: End If;
380: End If;
381: Close jtf_rule_cur;