Query to get costing by department

 SELECT PD.NAME AS DEPT_NAME,

        PD.STATUS,

                                SUBSTR(PCAF.EFFECTIVE_START_DATE,1,10) AS COSTING_START_DATE,

                                SUBSTR(PCAF.EFFECTIVE_END_DATE,1,10) AS COSTING_END_DATE,

       (PCA.PROPORTION * 100) AS PERCENTAGE,

                   PCA.SEGMENT1 AS COMPANY,

       PCA.SEGMENT2 AS COST_CENTER

  FROM PAY_COST_ALLOC_ACCOUNTS PCA,

       PAY_COST_ALLOCATIONS_F PCAF,

                   PER_DEPARTMENTS PD

WHERE PCA.SOURCE_SUB_TYPE = 'COST'

   AND PCA.COST_ALLOCATION_RECORD_ID = PCAF.COST_ALLOCATION_RECORD_ID

   AND PCAF.SOURCE_ID = PD.ORGANIZATION_ID

   AND PCAF.SOURCE_TYPE = 'ORG'

   AND TRUNC(SYSDATE) BETWEEN PCAF.EFFECTIVE_START_DATE AND PCAF.EFFECTIVE_END_DATE

   AND TRUNC(SYSDATE) BETWEEN PD.EFFECTIVE_START_DATE AND PD.EFFECTIVE_END_DATE

ORDER BY PD.NAME