APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on DUAL

Line 167: from dual;

163: If p_id1 is not null and p_id2 is not null and p_name is null then
164: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
165: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
166: into l_where_clause
167: from dual;
168: x_where_clause := l_where_clause;
169: Elsif p_name is not null then
170: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
171: ' NAME like '||''''||p_name||'%'||''''

Line 173: from dual;

169: Elsif p_name is not null then
170: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
171: ' NAME like '||''''||p_name||'%'||''''
172: into l_where_clause
173: from dual;
174: End If;
175: End If;
176: Close jtf_party_role_cur;
177: End Get_Party;

Line 651: from dual;

647: If p_id1 is not null and p_id2 is not null and p_name is null then
648: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
649: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
650: into l_where_clause
651: from dual;
652: x_where_clause := l_where_clause;
653: Elsif p_name is not null then
654: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
655: ' NAME = '||''''||p_name||''''

Line 657: from dual;

653: Elsif p_name is not null then
654: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
655: ' NAME = '||''''||p_name||''''
656: into l_where_clause
657: from dual;
658: End If;
659: /*
660: select ' SELECT count(*) rec_count'||
661: ' FROM '||x_from_clause||

Line 664: into l_query_string from dual;

660: select ' SELECT count(*) rec_count'||
661: ' FROM '||x_from_clause||
662: decode(x_where_clause,null,' ',' WHERE ')||x_where_clause||
663: decode(x_order_by_clause,null,null,' ORDER BY ')||x_order_by_clause
664: into l_query_string from dual;
665: l_rec_count := 0;
666: Open contact_count_curs for l_query_string;
667: Fetch contact_count_curs into l_rec_count;
668: If l_rec_count = 0