GHR CPDF Organizational Component Translation

SELECT     AGENCY,
                 COMPONENT,
                 TITLE,
	 MIN(L_COUNT)
FROM     (SELECT FROM_BASIC_PAY SORT_BY,
                 AGENCY_CODE AGENCY,
                 ORGANIZATIONAL_COMPONENT COMPONENT,
                 LPAD(' ',2 * (FROM_LOCALITY_ADJ - 1))
                  ||RPAD(FROM_OCC_CODE
                      ||FROM_NATIONAL_IDENTIFIER,179,'   ') TITLE,
                 NVL(FROM_LOCALITY_ADJ,0) L_LEVEL,
                 FROM_BASIC_PAY L_COUNT
           FROM   GHR_CPDF_TEMP
           WHERE  REPORT_TYPE = 'GHRCPDFO'
           AND SESSION_ID = USERENV('sessionid')
          order by L_COUNT )
GROUP BY AGENCY,COMPONENT,TITLE
ORDER BY 4