APPS.IEU_PUB dependencies on DUAL

Line 210: dual;

206: (instr(l_res_cat_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
207: into
208: l_enum_bind_var_flag
209: from
210: dual;
211:
212: If (l_rtnode_bind_var_flag = 'T')
213: then
214:

Line 224: FROM DUAL;

220: (b.node_id = p_node_id) )
221: then
222: SELECT REPLACE(l_where_clause,b.bind_var_name,b.bind_var_value)
223: INTO l_where_clause
224: FROM DUAL;
225:
226: -- Set the Bind variables for Runtime Where Clause
227: SELECT REPLACE(l_extra_where_clause,b.bind_var_name,b.bind_var_value)
228: INTO l_extra_where_clause

Line 229: FROM DUAL;

225:
226: -- Set the Bind variables for Runtime Where Clause
227: SELECT REPLACE(l_extra_where_clause,b.bind_var_name,b.bind_var_value)
228: INTO l_extra_where_clause
229: FROM DUAL;
230:
231:
232: end if;
233:

Line 243: FROM DUAL;

239: if (l_enum_bind_var_flag = 'T')
240: then
241: SELECT REPLACE(l_where_clause,':resource_id',p_resource_id)
242: INTO l_where_clause
243: FROM DUAL;
244: end if;
245:
246: end if;
247:

Line 368: dual;

364: (instr(l_res_cat_where_clause, ':resource_id', 1, 1)), 0, 'F','T' )
365: into
366: l_enum_bind_var_flag
367: from
368: dual;
369:
370: If (l_rtnode_bind_var_flag = 'T')
371: then
372:

Line 382: FROM DUAL;

378: (b.node_id = p_node_id) )
379: then
380: SELECT REPLACE(l_where_clause,b.bind_var_name,b.bind_var_value)
381: INTO l_where_clause
382: FROM DUAL;
383:
384: -- Set the Bind variables for Runtime Where Clause
385: SELECT REPLACE(l_extra_where_clause,b.bind_var_name,b.bind_var_value)
386: INTO l_extra_where_clause

Line 387: FROM DUAL;

383:
384: -- Set the Bind variables for Runtime Where Clause
385: SELECT REPLACE(l_extra_where_clause,b.bind_var_name,b.bind_var_value)
386: INTO l_extra_where_clause
387: FROM DUAL;
388:
389: l_rec_count := l_rec_count + 1;
390: X_BIND_VARIABLE_RECORD_LIST(l_rec_count).BIND_VAR_NAME := b.bind_var_name;
391: X_BIND_VARIABLE_RECORD_LIST(l_rec_count).BIND_VAR_VALUE := b.bind_var_value;

Line 404: FROM DUAL;

400: if (l_enum_bind_var_flag = 'T')
401: then
402: SELECT REPLACE(l_where_clause,':resource_id',p_resource_id)
403: INTO l_where_clause
404: FROM DUAL;
405: end if;
406:
407: end if;
408: