dbo.mspProjectInsert dbo.mspProjectGetByID dbo.mspProjectGetAll dbo.mspProjectUpdateByID dbo.mspProjectUpdateGLCodeByID dbo.mspProjectUpdateOverallEvalByID dbo.mspProjectUpdatePPStatusByID SELECT tblProject_Service.Project_ServiceID, tblProject_Service.ProjectID, tblProject_Service.ServiceID, tblProject_Service.CreatedOn, tblProject_Service.CreatedBy,tblProject_Service.ModifiedOn, tblProject_Service.ModifiedBy,tluService.ServiceStringID,tluService.ServiceText FROM tblProject_Service INNER JOIN tluService ON tblProject_Service.ServiceID = tluService.ServiceID ORDER BY tblProject_Service.Project_ServiceID dbo.mspProject_ServiceGetByProjectID dbo.mspProject_ServiceInsertUpdateByProjectID dbo.mspDateVenueGetByProjectID dbo.mspDateVenueInsertUpdateControl dbo.mspProjectDateUpdateProposedProjectDateByID DELETE FROM [dbo].[tblProject_TargetSegment] WHERE (([Project_TargetSegmentID] = @Original_Project_TargetSegmentID) AND ([ProjectID] = @Original_ProjectID) AND ([TargetSegmentID] = @Original_TargetSegmentID) AND ((@IsNull_IsPrimaryTargetYN = 1 AND [IsPrimaryTargetYN] IS NULL) OR ([IsPrimaryTargetYN] = @Original_IsPrimaryTargetYN)) AND ([CreatedOn] = @Original_CreatedOn) AND ((@IsNull_CreatedBy = 1 AND [CreatedBy] IS NULL) OR ([CreatedBy] = @Original_CreatedBy)) AND ([ModifiedOn] = @Original_ModifiedOn) AND ((@IsNull_ModifiedBy = 1 AND [ModifiedBy] IS NULL) OR ([ModifiedBy] = @Original_ModifiedBy))) INSERT INTO [dbo].[tblProject_TargetSegment] ([ProjectID], [TargetSegmentID], [IsPrimaryTargetYN], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy]) VALUES (@ProjectID, @TargetSegmentID, @IsPrimaryTargetYN, @CreatedOn, @CreatedBy, @ModifiedOn, @ModifiedBy); SELECT Project_TargetSegmentID, ProjectID, TargetSegmentID, IsPrimaryTargetYN, CreatedOn, CreatedBy, ModifiedOn, ModifiedBy FROM tblProject_TargetSegment WHERE (Project_TargetSegmentID = SCOPE_IDENTITY()) SELECT Project_TargetSegmentID, ProjectID, TargetSegmentID, IsPrimaryTargetYN, CreatedOn, CreatedBy, ModifiedOn, ModifiedBy FROM dbo.tblProject_TargetSegment UPDATE [dbo].[tblProject_TargetSegment] SET [ProjectID] = @ProjectID, [TargetSegmentID] = @TargetSegmentID, [IsPrimaryTargetYN] = @IsPrimaryTargetYN, [CreatedOn] = @CreatedOn, [CreatedBy] = @CreatedBy, [ModifiedOn] = @ModifiedOn, [ModifiedBy] = @ModifiedBy WHERE (([Project_TargetSegmentID] = @Original_Project_TargetSegmentID) AND ([ProjectID] = @Original_ProjectID) AND ([TargetSegmentID] = @Original_TargetSegmentID) AND ((@IsNull_IsPrimaryTargetYN = 1 AND [IsPrimaryTargetYN] IS NULL) OR ([IsPrimaryTargetYN] = @Original_IsPrimaryTargetYN)) AND ([CreatedOn] = @Original_CreatedOn) AND ((@IsNull_CreatedBy = 1 AND [CreatedBy] IS NULL) OR ([CreatedBy] = @Original_CreatedBy)) AND ([ModifiedOn] = @Original_ModifiedOn) AND ((@IsNull_ModifiedBy = 1 AND [ModifiedBy] IS NULL) OR ([ModifiedBy] = @Original_ModifiedBy))); SELECT Project_TargetSegmentID, ProjectID, TargetSegmentID, IsPrimaryTargetYN, CreatedOn, CreatedBy, ModifiedOn, ModifiedBy FROM tblProject_TargetSegment WHERE (Project_TargetSegmentID = @Project_TargetSegmentID) dbo.mspVenueGetByID dbo.mspProjectDateGetByID dbo.mspProjectDateUpdateEvalByID dbo.mspProjectCommitteeGetByProjectID dbo.mspBoardPortfolioGetByID dbo.mspProjectInsert dbo.mspCOEDataInsertUpdateControl