APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on DUAL

Line 352: from dual;

348: If ( p_name is not null and p_name <> OKC_API.G_MISS_CHAR) then
349: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
350: ' DESCRIPTION like :name'
351: into l_where_clause
352: from dual;
353: x_where_clause := l_where_clause;
354: End If;
355:
356: If p_id1 is not null and p_id1 <> OKC_API.G_MISS_CHAR

Line 361: from dual;

357: and p_id2 is not null and p_id2 <> OKC_API.G_MISS_CHAR then
358: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
359: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
360: into l_where_clause
361: from dual;
362: x_where_clause := l_where_clause;
363: End If;
364: End If;
365: Close jtf_rule_cur;