DBA Data[Home] [Help]

VIEW: HR.PAY_RETRO_NOTIF_REPORTS#

Source

View Text - Preformatted

select REPORT_ID REPORT_ID, PAYROLL_ID PAYROLL_ID, REPORT_DATE REPORT_DATE, ASSIGNMENT_ID ASSIGNMENT_ID, ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID, EVENT_GROUP_ID EVENT_GROUP_ID, DATE_PROCESSED DATE_PROCESSED, DATE_EARNED DATE_EARNED, CHANGE_TYPE CHANGE_TYPE, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID from "HR"."PAY_RETRO_NOTIF_REPORTS"
View Text - HTML Formatted

SELECT REPORT_ID REPORT_ID
, PAYROLL_ID PAYROLL_ID
, REPORT_DATE REPORT_DATE
, ASSIGNMENT_ID ASSIGNMENT_ID
, ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, EVENT_GROUP_ID EVENT_GROUP_ID
, DATE_PROCESSED DATE_PROCESSED
, DATE_EARNED DATE_EARNED
, CHANGE_TYPE CHANGE_TYPE
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM "HR"."PAY_RETRO_NOTIF_REPORTS"