DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on QA_CHARS

Line 294: qa_chars qc

290: qpct.High_Value ,
291: qc.datatype,
292: qc.char_id
293: FROM qa_plan_collection_triggers qpct,
294: qa_chars qc
295: WHERE qpct.Collection_Trigger_ID = qc.char_id and
296: qpct.plan_transaction_id = p_plan_txn_id) LOOP
297:
298: IF NOT elements.EXISTS(plan_record.char_id) THEN

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 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: