DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on QA_PLAN_CHARS

Line 534: FROM qa_plan_chars qpc, qa_chars qc

530: -- ntungare
531: --
532: SELECT qpc.char_id, qpc.result_column_name, qc.datatype,
533: NVL(qpc.default_value, qc.default_value) default_value
534: FROM qa_plan_chars qpc, qa_chars qc
535: WHERE plan_id = p_plan_id AND qpc.char_id = qc.char_id) LOOP
536:
537: IF elements.EXISTS(c.char_id) THEN
538: l_insert_columns := l_insert_columns || ',' || c.result_column_name;

Line 929: from qa_plan_chars

925: --
926: CURSOR C1 IS
927: /*
928: SELECT char_id
929: from qa_plan_chars
930: where plan_id = p_plan_id
931: and enabled_flag = 1;
932: */
933: SELECT qpc.char_id,

Line 936: from qa_plan_chars qpc, qa_chars qc

932: */
933: SELECT qpc.char_id,
934: NVL(qpc.default_value, qc.default_value) default_value,
935: qc.datatype
936: from qa_plan_chars qpc, qa_chars qc
937: where qpc.plan_id = p_plan_id
938: and qpc.char_id = qc.char_id
939: and qpc.enabled_flag = 1;
940: