Blame | 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
/* 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