APPS.QLTVCREB dependencies on QA_PLAN_CHARS

Line 276: -- This cursor loops through qa_plan_chars to find all

272:
273: fk fk_cursor%ROWTYPE;
274:
275: --
276: -- This cursor loops through qa_plan_chars to find all
277: -- plan_id and result_column_name for each collection element.
278: --
279: -- The decode() function and distinct are there to cleverly
280: -- eliminate all but one row of hardcoded elements. We only

Line 295: FROM qa_plan_chars qpc, qa_chars qc

291: decode(qc.hardcoded_column, null, qpc.plan_id, 0) plan_id,
292: upper(qpc.result_column_name) result_column_name,
293: qc.name,
294: qc.hardcoded_column
295: FROM qa_plan_chars qpc, qa_chars qc
296: WHERE qc.char_id = qpc.char_id AND
297: qpc.enabled_flag = 1 AND
298: qc.enabled_flag = 1
299: ORDER BY qc.hardcoded_column, qc.name;

Line 374: -- more efficient to go through qa_plan_chars to avoid performing

370: --
371:
372: --
373: -- One option is to go through each element, but it is slightly
374: -- more efficient to go through qa_plan_chars to avoid performing
375: -- too many database parses.
376: --
377: -- FOR element IN elements_cursor LOOP
378: --

Line 689: qa_plan_chars qpc

685: qc.FK_DESCRIPTION,
686: qc.FK_ADD_WHERE,
687: qc.DATATYPE
688: FROM qa_chars qc,
689: qa_plan_chars qpc
690: WHERE qc.char_id = qpc.char_id
691: AND qpc.plan_id = x_plan_id
692: ORDER BY qpc.prompt_sequence;
693:

Line 1006: FROM qa_plan_chars qpc, qa_chars qc

1002: SELECT qpc.result_column_name,
1003: upper(translate(qc.name,' ''*{}','_____')) name,
1004: qc.hardcoded_column,
1005: qc.developer_name
1006: FROM qa_plan_chars qpc, qa_chars qc
1007: WHERE qpc.char_id = qc.char_id AND qpc.plan_id = x_plan_id
1008: ORDER BY prompt_sequence;
1009:
1010: --