select --(SELECT  DEPT_NAME FROM HRM_DEPT where   nvl(company_no,0)= AP.COMPANY_NO AND DEPT_NO =E.DEPT_NO) Name_of_Department,

count(AP.EMP_NO) AS NO_OF_EMPLOYEES

, SUM(AP.OLD_BASIC) AS Present_Basic_Salary

,SUM(AP.OLD_GROSS_SALARY) AS Present_Gross_Salary

, SUM(s.basic) AS N_basic

, SUM(s.HOUSE_RENT) AS N_HR
, SUM(s.MEDICAL_ALLOW) AS N_M_A
, SUM(s.TRANSPORT_ALLOW) AS N_T_A
, SUM(s.UTILITY) AS  N_Utility
, SUM(s.SPECIAL_ALLOW) AS  N_SPL
, SUM(s.MOBILE_BILL) AS Mobile
, SUM(s.ENTERTAIN_ALLOW) AS N_Ent_allo
,SUM(AP.OLD_GROSS_SALARY + AP.PROMOTION_AMOUNT) AS New_Gross
,SUM(AP.PROMOTION_AMOUNT) AS INCREM_AMOUNT
, SUM(AP.PROMOTION_PERCENTAGE) AS Increm
--,APPROVED_REMARKS REMARKS

 from HRM_EMP_APPRAISAL AP ,  HRM_EMPLOYEE_PROFILE E, HRM_EMP_PROPOSE_SALARY s
--,HRM_SALES_AREA  H
WHERE AP.EMP_NO = E.EMPLOYEE_NO
and ap.EMP_APPRAISAL_NO =s.EMP_APPRAISAL_NO
--and AP.LOCATION_NO = H.HSA_AREA_NO
and  nvl(s.ACTIVE_STATUS,'N')='Y'
GROUP BY AP.DEPT_NO