DBA Data[Home] [Help]

VIEW: HR.HR_ASSIGNMENT_SETS#

Source

View Text - Preformatted

select ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PAYROLL_ID PAYROLL_ID, ASSIGNMENT_SET_NAME ASSIGNMENT_SET_NAME, FORMULA_ID FORMULA_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HR"."HR_ASSIGNMENT_SETS"
View Text - HTML Formatted

SELECT ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PAYROLL_ID PAYROLL_ID
, ASSIGNMENT_SET_NAME ASSIGNMENT_SET_NAME
, FORMULA_ID FORMULA_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HR"."HR_ASSIGNMENT_SETS"