How to get a list of Ids and types for CPProjectType from the project table?
The below query will provide the list of Id's for the CPProjectType :
select * from codedetail where CodeType = 'CPProjectType'
select projectid, name, CPProjectType from Project where CPProjectType = '...'