880: ELSIF P_QUERY_TYPE = 3 THEN
881: DELETE MST_ORDER_SELECTION_CRITERIA
882: WHERE query_id = p_query_id;
883: ELSIF P_QUERY_TYPE = 4 THEN
884: DELETE MST_EXCEP_SELECTION_CRITERIA
885: WHERE query_id = p_query_id;
886: END IF;
887: DELETE mst_personal_query_results
888: WHERE query_id = p_query_id;
3793: SUPPLIERS ,SUPPLIER_IDS ,
3794: EXCEPTION_COUNT_TYPE ,EXCEPTION_COUNT_FROM ,
3795: EXCEPTION_COUNT_TO ,EXCEPTION_STATUS ,
3796: EXCEPTION_STATUS_IDS
3797: from mst_excep_selection_criteria
3798: where query_id = p_query_id;
3799:
3800: l_rec_excep cur_excep%ROWTYPE;
3801: