You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Compensation History tables and data

Received Response
14
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!