Compensation History tables and data

Hi All,

I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly.

SELECT hth.transaction_id,

    ct1.attribute4                     cycle_name,

    ct1.attribute5                     plan_name,

    ct1.attribute38                    submitted_by,

    hth.module_identifier,

    To_timestamp(ct1.attribute39, 'YYYY-MM-DD HH24:MI:SS') AS submitted_date,

    ct1.attribute7                     manager,

    apprv.comments,

    ct2.attribute12                    miscVal1,

    ct2.attribute14                    miscVal3

FROM  hrc_txn_header hth,

    cmp_transactions ct1,

    cmp_transactions ct2,

    cmp_cwb_approval_history apprv

WHERE hth.module_identifier = 'CompensationWorksheetApproval'

    AND hth.module_group = 'CMP'

    AND hth.object = 'CMP_TRANSACTIONS'

    AND hth.object_id = ct1.transaction_id