DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on DUAL

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

2019:
2020: BEGIN
2021:
2022:
2023: new_sql_statement := 'SELECT 1 FROM DUAL WHERE ' || '''' ||
2024: qa_core_pkg.dequote(value) || '''';
2025:
2026: new_sql_statement := new_sql_statement || ' IN ' || '(' ||
2027: sql_statement || ')';

Line 2623: from dual

2619: sql_string :=
2620: 'select *
2621: from
2622: (select ''x'' code, ''x'' description
2623: from dual
2624: where 1 = 2
2625: union
2626: select * from
2627: ( '|| sql_string ||

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

4758: ELSE
4759: --
4760: -- This is a catchall SQL that returns no value.
4761: --
4762: l_sql_string := 'SELECT ''x'', ''x'' FROM dual WHERE 1 = 2';
4763: open x_ref FOR l_sql_string;
4764: END IF;
4765:
4766: END get_comp_item_lov;

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

4962: -- To prevent client from bombing, open an empty cursor in case
4963: -- this function if called but there is no LOV!
4964: --
4965: OPEN x_ref FOR
4966: SELECT 'x', 'x' FROM dual WHERE 1 = 2;
4967: END IF;
4968:
4969: END get_plan_element_lov;
4970: