APPS.OKL_JTOT_EXTRACT dependencies on DUAL

Line 845: from dual;

841: If p_id1 is not null and p_id2 is not null and p_name is null then
842: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
843: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
844: into l_where_clause
845: from dual;
846: x_where_clause := l_where_clause;
847: Elsif p_name is not null then
848: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
849: ' NAME = '||''''||p_name||''''

Line 851: from dual;

847: Elsif p_name is not null then
848: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
849: ' NAME = '||''''||p_name||''''
850: into l_where_clause
851: from dual;
852: End If;
853: /*
854: select ' SELECT count(*) rec_count'||
855: ' FROM '||x_from_clause||

Line 858: into l_query_string from dual;

854: select ' SELECT count(*) rec_count'||
855: ' FROM '||x_from_clause||
856: decode(x_where_clause,null,' ',' WHERE ')||x_where_clause||
857: decode(x_order_by_clause,null,null,' ORDER BY ')||x_order_by_clause
858: into l_query_string from dual;
859: l_rec_count := 0;
860: Open contact_count_curs for l_query_string;
861: Fetch contact_count_curs into l_rec_count;
862: If l_rec_count = 0