q = q +" select Id,Title from sHrm.tEmployeeTypeGroupMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title";        
q = q + " select Id,Title from sHrm.tEmployeeTypeMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title";        
q = q + " select Id,Title from sHrm.tTargetGroupMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title"; 
q = q + " select Id,Title from sHrm.tGradeMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title";
q = q + " select Id,Title from sHrm.tEmployeeGroupMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title";
q = q + " select Id,Title from sHrm.tEmployeeSubTypeMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title";
q = q + " select Id,Title from sHrm.tQualificationMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title";
q=  q + " select Id,Title from sHrm.tEmployeeCompanyMaster where IsObsolete = @rIsObsolete and OrgId = @rOrgId order by Title";