/* Branch Details */
SELECT br.BRANCH_ID,
	   br.BRANCH_NAME,
	   br.RM_VTREE_FK,
	   proj.PROJ_ID,
	   proj.PROJ_NAME
  FROM BRANCHES br,
  	   DM_PROJECTS proj
 WHERE br.PROJ_ID = proj.PROJ_ID
   AND br.BRANCH_ID = :BRANCH_ID	   
  	   