Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_ASSIGNMENT_ACTION |
SELECT HR_BIS.BIS_DECODE_LOOKUP('ACTION_STATUS'
, PAA.ACTION_STATUS) ACTION_STATUS
, PAA.CHUNK_NUMBER
, PAA.ACTION_SEQUENCE
, PAA.SERIAL_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('ACTION_STATUS'
, PAA.SECONDARY_STATUS) SECONDARY_STATUS
, PAA.START_DATE
, PAA.END_DATE
, PAA.OBJECT_TYPE
, PAA.OBJECT_VERSION_NUMBER
, PAA.ACTION_STATUS ACTION_STATUS_CODE
, PAA.SECONDARY_STATUS SECONDARY_STATUS_CODE
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PAA.PAYROLL_ACTION_ID
, PAA.PRE_PAYMENT_ID
, PAA.TAX_UNIT_ID
, PAA.SOURCE_ACTION_ID
, PAA.RUN_TYPE_ID
, PAA.OBJECT_ID
FROM PAY_ASSIGNMENT_ACTIONS PAA WITH READ ONLY