[Home] [Help]
1261: --
1262: -- This function intelligently finding out parent plan record when child plan record information
1263: -- is passed. First find out parent_plan_id from qa_pc_plan_relationship. Then findout all
1264: -- element ids with which parent and child plans are related. Take only those elements which have
1265: -- link_flag = 1 in qa_pc_element_relationship table.
1266:
1267: -- Find the values of the elements from qa_results for the child plan. Then find the first record
1268: -- for the parent plan which has all the elements (only those related in the qa_pc_element_relation)
1269: -- same value for those of child plan. Return the parent record information.
1299: pe.child_char_id,
1300: qpc2.result_column_name child_database_column
1301: from
1302: qa_pc_plan_relationship pr,
1303: qa_pc_element_relationship pe,
1304: qa_plan_chars qpc1,
1305: qa_plan_chars qpc2
1306: where
1307: pr.plan_relationship_id = pe.plan_relationship_id and
2690: qa_plan_chars qpc
2691: WHERE qpc.plan_id = p_child_plan_id
2692: AND qpc.char_id NOT IN
2693: (SELECT child_char_id
2694: FROM qa_pc_element_relationship qper,
2695: qa_pc_plan_relationship qppr
2696: WHERE qper.plan_relationship_id = qppr.plan_relationship_id
2697: AND qppr.parent_plan_id = p_parent_plan_id
2698: AND qppr.child_plan_id = p_child_plan_id