DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on DUAL

Line 2004: new_sql_statement := 'SELECT 1 FROM DUAL WHERE ' || '''' ||

2000:
2001: BEGIN
2002:
2003:
2004: new_sql_statement := 'SELECT 1 FROM DUAL WHERE ' || '''' ||
2005: qa_core_pkg.dequote(value) || '''';
2006:
2007: new_sql_statement := new_sql_statement || ' IN ' || '(' ||
2008: sql_statement || ')';

Line 2599: from dual

2595: sql_string :=
2596: 'select *
2597: from
2598: (select ''x'' code, ''x'' description
2599: from dual
2600: where 1 = 2
2601: union
2602: select * from
2603: ( '|| sql_string ||

Line 4564: l_sql_string := 'SELECT ''x'', ''x'' FROM dual WHERE 1 = 2';

4560: ELSE
4561: --
4562: -- This is a catchall SQL that returns no value.
4563: --
4564: l_sql_string := 'SELECT ''x'', ''x'' FROM dual WHERE 1 = 2';
4565: open x_ref FOR l_sql_string;
4566: END IF;
4567:
4568: END get_comp_item_lov;

Line 4768: SELECT 'x', 'x' FROM dual WHERE 1 = 2;

4764: -- To prevent client from bombing, open an empty cursor in case
4765: -- this function if called but there is no LOV!
4766: --
4767: OPEN x_ref FOR
4768: SELECT 'x', 'x' FROM dual WHERE 1 = 2;
4769: END IF;
4770:
4771: END get_plan_element_lov;
4772: