pgcfc = CreateObject("Component", "components.general.progressnotes"); retiredcareplans = pgcfc.retire_careplans(#arguments.Careplan_ID#); UPDATE #Request.prefix_db_agency#.pCareplan SET Proc_QA = , Date_Change = , Change_by = WHERE Careplan_ID = ANd Status = 0 SELECT e.Emp_ID FROM #Request.prefix_db_agency#.pCareplan c LEFT JOIN #Request.prefix_db_agency#.assessment_assign a ON COALESCE(NULLIF(a.Parent_Assmt_ID, 0), a.Assmt_ID) = c.Assmt_ID JOIN #Request.prefix_db_agency#.pAssessments ass ON ass.Assmt_ID = a.Assmt_ID AND ass.Status = 0 AND ass.F27 = c.Skill JOIN #Request.prefix_db_lookup#.pEmployee e ON e.Emp_ID = a.Emp_ID AND e.Status = 0 WHERE c.Careplan_ID = AND c.Status = 0 LIMIT 1 SELECT ID, Emp_Count FROM #Request.prefix_db_agency#.Dash_emp_count WHERE Header = AND Emp_ID = AND Status = 0 AND Daily_QA_Date = ORDER BY ID DESC LIMIT 1 UPDATE #Request.prefix_db_agency#.Dash_emp_count SET Emp_Count = WHERE ID = INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status) VALUES ( , , , , , ) pgcfc = CreateObject("Component", "components.general.progressnotes"); retiredcareplans = pgcfc.retire_careplans(#arguments.Careplan_ID#); UPDATE #Request.prefix_db_agency#.pCareplan SET Status = 0, QA_approve = , Date_Change = , Change_by = WHERE Careplan_ID = ANd Status = 1 pgcfc = CreateObject("Component", "components.general.progressnotes"); retiredcareplans = pgcfc.retire_assessments(#arguments.Assmt_ID#); UPDATE #Request.prefix_db_agency#.pAssessments SET QA_Count = , Record_Mod_Date = , Record_Mod_By = WHERE Assmt_ID = ANd Status = 0 pgcfc = CreateObject("Component", "components.general.progressnotes"); retiredschedules = pgcfc.retire_schedules(#arguments.Schedule_ID#); UPDATE #Request.prefix_db_agency#.pSchedules SET QA_View = , Date_Change = , Change_by = WHERE Schedule_ID = ANd Status = 0 pgcfc = CreateObject("Component", "components.general.progressnotes"); retiredschedules = pgcfc.retire_schedules(#arguments.Schedule_ID#); UPDATE #Request.prefix_db_agency#.pSchedules SET QA_Proc = , pgnotesdraft = , Date_Change = , Change_by = WHERE Schedule_ID = ANd Status = 0