DBA Data[Home] [Help]

VIEW: HR.HR_PYRL_DELTA_SYNC#

Source

View Text - Preformatted

select PAYROLL_ID PAYROLL_ID, PAYROLL_NAME PAYROLL_NAME, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EFFECTIVE_DATE EFFECTIVE_DATE, EFFECTIVE_STATUS EFFECTIVE_STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, STATUS STATUS, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE, EVENT_KEY EVENT_KEY from "HR"."HR_PYRL_DELTA_SYNC"
View Text - HTML Formatted

SELECT PAYROLL_ID PAYROLL_ID
, PAYROLL_NAME PAYROLL_NAME
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, EFFECTIVE_STATUS EFFECTIVE_STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, STATUS STATUS
, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE
, EVENT_KEY EVENT_KEY
FROM "HR"."HR_PYRL_DELTA_SYNC"