946: --should not have '@' at the beginning or end
947: --
948:
949: SelectFromClause :=
950: qa_results_interface_pkg.get_plan_vqr_sql (p_plan_id);
951:
952: --below for direct link, first check coll id and occ values
953:
954: if (p_collection_id is not null and p_occurrence is not null
981: WhereClause VARCHAR2(20000);
982: BEGIN
983:
984: SelectFromClause :=
985: qa_results_interface_pkg.get_plan_vqr_sql (p_child_plan_id);
986:
987:
988: -- Bug 9773013.Forward porting bug#9207821.Added condition of status = 2 to pick only
989: -- valid child records.pdube
1007: WhereClause VARCHAR2(20000);
1008: BEGIN
1009:
1010: SelectFromClause :=
1011: qa_results_interface_pkg.get_plan_vqr_sql (p_parent_plan_id);
1012:
1013:
1014: -- Bug 9773013 FP to 9492520.Added condition for status.pdube
1015: WhereClause := ' WHERE PLAN_ID = ' || p_parent_plan_id