APPS.QLTTRAWB dependencies on QA_PLAN_CHARS

Line 3103: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri

3099: p_col_name IN VARCHAR2) RETURN VARCHAR2 IS
3100:
3101: CURSOR c IS
3102: SELECT name
3103: FROM qa_chars qc, qa_plan_chars qpc, qa_results_interface qri
3104: WHERE qc.char_id = qpc.char_id
3105: AND qpc.plan_id = qri.plan_id
3106: AND qpc.result_column_name = p_col_name
3107: AND qri.group_id = p_group_id;

Line 5256: FROM QA_CHARS QC, QA_PLAN_CHARS_V QPCV

5252: QPCV.RESULT_COLUMN_NAME, QPCV.ENABLED_FLAG,
5253: QPCV.MANDATORY_FLAG, QC.DATATYPE, QPCV.DECIMAL_PRECISION,
5254: QC.SQL_VALIDATION_STRING, QPCV.VALUES_EXIST_FLAG,
5255: UPPER(REPLACE(QC.NAME, ' ', '_')) CHAR_NAME, READ_ONLY_FLAG
5256: FROM QA_CHARS QC, QA_PLAN_CHARS_V QPCV
5257: WHERE QPCV.PLAN_ID = X_PLAN_ID
5258: AND QPCV.CHAR_ID = QC.CHAR_ID) LOOP
5259: I := I + 1;
5260: CHAR_ID_TABLE(I) := CHARREC.CHAR_ID;

Line 5285: -- definition of qa_plan_chars_v which was used before this fix.

5281: --
5282:
5283: -- Just added the nvl condition for decimal_precision column.
5284: -- This was done to have the select statement similar to the
5285: -- definition of qa_plan_chars_v which was used before this fix.
5286: -- Bug 4254876.suramasw
5287:
5288: SELECT
5289: qpc.char_id,

Line 5316: qa_plan_chars qpc

5312: values_exist_flag_table,
5313: read_only_flag_table
5314: FROM
5315: qa_chars qc,
5316: qa_plan_chars qpc
5317: WHERE
5318: qpc.plan_id = x_plan_id AND
5319: qpc.char_id = qc.char_id;
5320:

Line 7311: FROM QA_PLAN_CHARS QPC, qa_chars qc

7307:
7308: -- Bug 4958776. SQL Repository Fix SQL ID: 15009199
7309: -- replacing view with base tables
7310: FOR RESREC IN (SELECT QPC.CHAR_ID, QPC.RESULT_COLUMN_NAME, QC.DATATYPE
7311: FROM QA_PLAN_CHARS QPC, qa_chars qc
7312: WHERE QPC.PLAN_ID = X_PLAN_ID
7313: AND QC.CHAR_ID = QPC.CHAR_ID ) LOOP
7314: NUM_COLS := NUM_COLS + 1;
7315: RESULT_COLUMN_ID_TABLE(NUM_COLS) := RESREC.CHAR_ID;

Line 7523: FROM QA_PLAN_CHARS QPC,

7519:
7520: -- End of changes for bug 2548710.
7521:
7522: FOR COLUMN_NAMES_REC IN (SELECT QPC.RESULT_COLUMN_NAME
7523: FROM QA_PLAN_CHARS QPC,
7524: QA_CHARS QC
7525: WHERE QPC.PLAN_ID = X_PLAN_ID
7526: AND QPC.CHAR_ID = QC.CHAR_ID) LOOP
7527: I := I + 1;

Line 7791: qa_plan_chars qpc

7787: values_exist_flag_table,
7788: read_only_flag_table
7789: FROM
7790: qa_chars qc,
7791: qa_plan_chars qpc
7792: WHERE
7793: qpc.plan_id = x_plan_id AND
7794: qpc.char_id = qc.char_id;
7795:

Line 7957: FROM QA_PLAN_CHARS

7953:
7954: I := 0;
7955: -- Bug 4958776. SQL Repository Fix SQL ID: 15009245
7956: FOR CHARREC IN (SELECT RESULT_COLUMN_NAME
7957: FROM QA_PLAN_CHARS
7958: WHERE PLAN_ID = X_PLAN_ID) LOOP
7959: I := I + 1;
7960: RESULT_COLUMN_NAME_TABLE(I) := CHARREC.RESULT_COLUMN_NAME;
7961: END LOOP;