DBA Data[Home] [Help]

VIEW: HR.PAY_RETRO_ASSIGNMENTS#

Source

View Text - Preformatted

select RETRO_ASSIGNMENT_ID RETRO_ASSIGNMENT_ID, ASSIGNMENT_ID ASSIGNMENT_ID, REPROCESS_DATE REPROCESS_DATE, START_DATE START_DATE, APPROVAL_STATUS APPROVAL_STATUS, SUPERSEDING_RETRO_ASG_ID SUPERSEDING_RETRO_ASG_ID, RETRO_ASSIGNMENT_ACTION_ID RETRO_ASSIGNMENT_ACTION_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."PAY_RETRO_ASSIGNMENTS"
View Text - HTML Formatted

SELECT RETRO_ASSIGNMENT_ID RETRO_ASSIGNMENT_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, REPROCESS_DATE REPROCESS_DATE
, START_DATE START_DATE
, APPROVAL_STATUS APPROVAL_STATUS
, SUPERSEDING_RETRO_ASG_ID SUPERSEDING_RETRO_ASG_ID
, RETRO_ASSIGNMENT_ACTION_ID RETRO_ASSIGNMENT_ACTION_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."PAY_RETRO_ASSIGNMENTS"