Blame | Last modification | View Log | RSS feed
/* Branches Combo */ SELECT br.BRANCH_ID, br.BRANCH_NAME, DECODE ( :BRANCH_ID, br.BRANCH_ID, 'selected', NULL ) AS SELECTED FROM BRANCHES br WHERE br.PROJ_ID = :PROJ_ID ORDER BY UPPER(br.BRANCH_NAME)
/* Branches Combo */
SELECT br.BRANCH_ID,
br.BRANCH_NAME,
DECODE ( :BRANCH_ID,
br.BRANCH_ID, 'selected',
NULL ) AS SELECTED
FROM BRANCHES br
WHERE br.PROJ_ID = :PROJ_ID
ORDER BY UPPER(br.BRANCH_NAME)