APPS.OKL_VP_JTF_PARTY_NAME_PVT dependencies on DUAL

Line 133: from dual;

129: If p_id1 is not null and p_id2 is not null and p_name is null then
130: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
131: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
132: into l_where_clause
133: from dual;
134: x_where_clause := l_where_clause;
135: Elsif p_name is not null then
136: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
137: ' NAME like '||''''||p_name||'%'||''''

Line 139: from dual;

135: Elsif p_name is not null then
136: select x_where_clause || decode(x_where_clause,null,null,' AND ')||
137: ' NAME like '||''''||p_name||'%'||''''
138: into l_where_clause
139: from dual;
140: End If;
141: End If;
142: Close jtf_party_role_cur;
143: End Get_Party;

Line 667: from dual;

663: If p_id1 is not null and p_id2 is not null and p_name is null then
664: select '(' || x_where_clause || ')' || decode(x_where_clause,null,null,' AND ')||
665: ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
666: into l_where_clause
667: from dual;
668: x_where_clause := l_where_clause;
669: Elsif p_name is not null then
670: select '(' || x_where_clause || ')' || decode(x_where_clause,null,null,' AND ')||
671: ' NAME like '||''''||p_name||'%'||''''

Line 673: from dual;

669: Elsif p_name is not null then
670: select '(' || x_where_clause || ')' || decode(x_where_clause,null,null,' AND ')||
671: ' NAME like '||''''||p_name||'%'||''''
672: into l_where_clause
673: from dual;
674: End If;
675: End If;
676: Close jtf_contact_cur;
677: End get_contact;