Query to extract Position 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,
    hp.position_code,
    pldg.name leslative_data_grp_name,
    pcac.segment2,
    pcac.segment3,
    pcac.segment4,
    pcac.segment5,
    pcac.proportion
FROM
    pay_cost_allocations_f pca,
    hr_all_positions_f hp,
    per_legislative_data_groups_tl pldg,
    pay_cost_alloc_accounts pcac
WHERE
    source_type = 'POS'
    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   trunc(SYSDATE) BETWEEN hp.effective_start_date AND hp.effective_end_date