Query to extract Department Costing Information

 select source_type,
TO_CHAR(pca.effective_start_date,'DD-MON-YYYY') effective_start_date,
TO_CHAR(pca.effective_end_date,'DD-MON-YYYY') effective_end_date,
pd.name,
pldg.name leslative_data_grp_name,
'UOB' set_code,
pcac.segment3
from pay_cost_allocations_f pca,
        per_departments pd,
        per_legislative_data_groups_tl pldg,
pay_cost_alloc_accounts pcac
    where source_type='ORG'
and pca.source_id=pd.organization_id
and pca.legislative_data_group_id=pldg.legislative_data_group_id
and pca.cost_allocation_record_id=pcac.cost_allocation_record_id