Query to extract Assignment 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,
prgd_a.assignment_number,
pldg.name leslative_data_grp_name,
pcac.segment2,
pcac.segment3,
pcac.segment4,
pcac.segment5
from pay_cost_allocations_f pca,
     per_legislative_data_groups_tl pldg,
     pay_cost_alloc_accounts pcac,
pay_rel_groups_dn prgd_a 
    where source_type='ASG'
--and pca.source_id=hp.position_id
and pca.legislative_data_group_id=pldg.legislative_data_group_id
and pca.cost_allocation_record_id=pcac.cost_allocation_record_id
and prgd_a.relationship_group_id=pca.source_id
order by prgd_a.assignment_number