DBA Data[Home] [Help]

APPS.QA_BIS dependencies on QA_PLAN_CHARS

Line 198: -- Performance notes: Will be more efficient if qa_plan_chars

194: -- Dynamically construct a decode function that decodes the
195: -- value for a softcoded collection element. The decode
196: -- statement started at the end of s.
197: --
198: -- Performance notes: Will be more efficient if qa_plan_chars
199: -- has an index on char_id.
200: --
201: x_plan_id number;
202: x_result_column_name varchar2(30);

Line 205: FROM qa_plan_chars

201: x_plan_id number;
202: x_result_column_name varchar2(30);
203: CURSOR c IS
204: SELECT plan_id, result_column_name
205: FROM qa_plan_chars
206: WHERE char_id = x_char_id;
207:
208: --
209: -- Bug 1357601. The decode statement used to "straighten" softcoded