Go to most recent revision | Details | Last modification | View Log | RSS feed
/* 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