SELECT * FROM #Request.prefix_db_lookup#.oasis_lookup WHERE status = AND assessment = AND wizard = ' /> SELECT * FROM #Request.prefix_db_lookup#.OASIS_Error_Check WHERE status = AND Assessment = AND Page_No = SELECT #geterror.F_Item# as F_Item_value FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = 0 SELECT #geterror.F_Item2# as F_Item2_value FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = 0 SELECT * FROM geterror WHERE F_Item = '#geterror.F_Item#' AND (F_Answer = '#F_Answer_value#' OR F_Answer = '#LEFT(F_Answer_value,1)#') AND F_Item2 = '#geterror.F_Item2#' AND (F_Answer_2 = '#F_Answer2_value#' OR F_Answer_2 = '#LEFT(F_Answer2_value,1)#') SELECT * FROM geterror WHERE ID IN (#ids#) ORDER BY Message ASC ' /> SELECT DISTINCT answer_label, ques_identifier FROM #Request.prefix_db_lookup#.assessment_questions_lookup WHERE assessment_reason = AND Deleted = 0 SELECT * FROM #Request.prefix_db_lookup#.OASIS_Error_Check WHERE status = AND Assessment = AND Page_No = SELECT #geterror.F_Item# AS F_Item_value FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = 0 SELECT #geterror.F_Item2# AS F_Item2_value FROM #Request.prefix_db_agency#.pAssessments WHERE Assmt_ID = AND status = 0 SELECT * FROM geterror WHERE F_Item = '#geterror.F_Item#' AND (F_Answer = '#F_Answer_value#' OR F_Answer = '#LEFT(F_Answer_value,1)#') AND F_Item2 = '#geterror.F_Item2#' AND (F_Answer_2 = '#F_Answer2_value#' OR F_Answer_2 = '#LEFT(F_Answer2_value,1)#') SELECT * FROM geterror WHERE ID IN (#ids#) ORDER BY Message ASC " />