VIEW: HR.PER_CAGR_ENTITLEMENT_RESULTS#

Source

View Text - Preformatted

select CAGR_ENTITLEMENT_RESULT_ID CAGR_ENTITLEMENT_RESULT_ID, CAGR_REQUEST_ID CAGR_REQUEST_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, START_DATE START_DATE, END_DATE END_DATE, COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID, CAGR_ENTITLEMENT_ITEM_ID CAGR_ENTITLEMENT_ITEM_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, INPUT_VALUE_ID INPUT_VALUE_ID, CAGR_API_ID CAGR_API_ID, CAGR_API_PARAM_ID CAGR_API_PARAM_ID, CATEGORY_NAME CATEGORY_NAME, CAGR_ENTITLEMENT_ID CAGR_ENTITLEMENT_ID, CAGR_ENTITLEMENT_LINE_ID CAGR_ENTITLEMENT_LINE_ID, ASSIGNMENT_ID ASSIGNMENT_ID, VALUE VALUE, UNITS_OF_MEASURE UNITS_OF_MEASURE, RANGE_FROM RANGE_FROM, RANGE_TO RANGE_TO, GRADE_SPINE_ID GRADE_SPINE_ID, PARENT_SPINE_ID PARENT_SPINE_ID, STEP_ID STEP_ID, FROM_STEP_ID FROM_STEP_ID, TO_STEP_ID TO_STEP_ID, BENEFICIAL_FLAG BENEFICIAL_FLAG, OIPL_ID OIPL_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, FORMULA_ID FORMULA_ID, CHOSEN_FLAG CHOSEN_FLAG, COLUMN_TYPE COLUMN_TYPE, COLUMN_SIZE COLUMN_SIZE, RETAINED_ENT_RESULT_ID RETAINED_ENT_RESULT_ID, FLEX_VALUE_SET_ID FLEX_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 from "HR"."PER_CAGR_ENTITLEMENT_RESULTS"

View Text - HTML Formatted

SELECT CAGR_ENTITLEMENT_RESULT_ID CAGR_ENTITLEMENT_RESULT_ID
, CAGR_REQUEST_ID CAGR_REQUEST_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID
, CAGR_ENTITLEMENT_ITEM_ID CAGR_ENTITLEMENT_ITEM_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, INPUT_VALUE_ID INPUT_VALUE_ID
, CAGR_API_ID CAGR_API_ID
, CAGR_API_PARAM_ID CAGR_API_PARAM_ID
, CATEGORY_NAME CATEGORY_NAME
, CAGR_ENTITLEMENT_ID CAGR_ENTITLEMENT_ID
, CAGR_ENTITLEMENT_LINE_ID CAGR_ENTITLEMENT_LINE_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, VALUE VALUE
, UNITS_OF_MEASURE UNITS_OF_MEASURE
, RANGE_FROM RANGE_FROM
, RANGE_TO RANGE_TO
, GRADE_SPINE_ID GRADE_SPINE_ID
, PARENT_SPINE_ID PARENT_SPINE_ID
, STEP_ID STEP_ID
, FROM_STEP_ID FROM_STEP_ID
, TO_STEP_ID TO_STEP_ID
, BENEFICIAL_FLAG BENEFICIAL_FLAG
, OIPL_ID OIPL_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, FORMULA_ID FORMULA_ID
, CHOSEN_FLAG CHOSEN_FLAG
, COLUMN_TYPE COLUMN_TYPE
, COLUMN_SIZE COLUMN_SIZE
, RETAINED_ENT_RESULT_ID RETAINED_ENT_RESULT_ID
, FLEX_VALUE_SET_ID FLEX_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
FROM "HR"."PER_CAGR_ENTITLEMENT_RESULTS"