DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on QA_PLAN_CHARS

Line 569: FROM qa_plan_chars qpc, qa_chars qc

565: -- ntungare
566: --
567: SELECT qpc.char_id, qpc.result_column_name, qc.datatype,
568: NVL(qpc.default_value, qc.default_value) default_value
569: FROM qa_plan_chars qpc, qa_chars qc
570: WHERE plan_id = p_plan_id AND qpc.char_id = qc.char_id) LOOP
571:
572: IF elements.EXISTS(c.char_id) THEN
573: l_insert_columns := l_insert_columns || ',' || c.result_column_name;

Line 964: from qa_plan_chars

960: --
961: CURSOR C1 IS
962: /*
963: SELECT char_id
964: from qa_plan_chars
965: where plan_id = p_plan_id
966: and enabled_flag = 1;
967: */
968: SELECT qpc.char_id,

Line 971: from qa_plan_chars qpc, qa_chars qc

967: */
968: SELECT qpc.char_id,
969: NVL(qpc.default_value, qc.default_value) default_value,
970: qc.datatype
971: from qa_plan_chars qpc, qa_chars qc
972: where qpc.plan_id = p_plan_id
973: and qpc.char_id = qc.char_id
974: and qpc.enabled_flag = 1;
975: