VIEW: HR.PER_CAGR_ENTITLEMENT_ITEMS#

Source

View Text - Preformatted

select CAGR_ENTITLEMENT_ITEM_ID CAGR_ENTITLEMENT_ITEM_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ITEM_NAME ITEM_NAME, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, INPUT_VALUE_ID INPUT_VALUE_ID, COLUMN_TYPE COLUMN_TYPE, COLUMN_SIZE COLUMN_SIZE, LEGISLATION_CODE LEGISLATION_CODE, BENEFICIAL_RULE BENEFICIAL_RULE, CAGR_API_ID CAGR_API_ID, CAGR_API_PARAM_ID CAGR_API_PARAM_ID, CATEGORY_NAME CATEGORY_NAME, UOM UOM, BENEFICIAL_FORMULA_ID BENEFICIAL_FORMULA_ID, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID, BENEFICIAL_RULE_VALUE_SET_ID BENEFICIAL_RULE_VALUE_SET_ID, MULTIPLE_ENTRIES_ALLOWED_FLAG MULTIPLE_ENTRIES_ALLOWED_FLAG, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OPT_ID OPT_ID, AUTO_CREATE_ENTRIES_FLAG AUTO_CREATE_ENTRIES_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PER_CAGR_ENTITLEMENT_ITEMS"

View Text - HTML Formatted

SELECT CAGR_ENTITLEMENT_ITEM_ID CAGR_ENTITLEMENT_ITEM_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ITEM_NAME ITEM_NAME
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, INPUT_VALUE_ID INPUT_VALUE_ID
, COLUMN_TYPE COLUMN_TYPE
, COLUMN_SIZE COLUMN_SIZE
, LEGISLATION_CODE LEGISLATION_CODE
, BENEFICIAL_RULE BENEFICIAL_RULE
, CAGR_API_ID CAGR_API_ID
, CAGR_API_PARAM_ID CAGR_API_PARAM_ID
, CATEGORY_NAME CATEGORY_NAME
, UOM UOM
, BENEFICIAL_FORMULA_ID BENEFICIAL_FORMULA_ID
, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, BENEFICIAL_RULE_VALUE_SET_ID BENEFICIAL_RULE_VALUE_SET_ID
, MULTIPLE_ENTRIES_ALLOWED_FLAG MULTIPLE_ENTRIES_ALLOWED_FLAG
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OPT_ID OPT_ID
, AUTO_CREATE_ENTRIES_FLAG AUTO_CREATE_ENTRIES_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PER_CAGR_ENTITLEMENT_ITEMS"