VIEW: APPS.PAYBV_ASSIGNMENT_ACTION

Source

View Text - Preformatted

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

View Text - HTML Formatted

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