VIEW: HR.PER_CAGR_RETAINED_RIGHTS#

Source

View Text - Preformatted

select CAGR_RETAINED_RIGHT_ID CAGR_RETAINED_RIGHT_ID, CAGR_ENTITLEMENT_RESULT_ID CAGR_ENTITLEMENT_RESULT_ID, ASSIGNMENT_ID ASSIGNMENT_ID, CAGR_ENTITLEMENT_ITEM_ID CAGR_ENTITLEMENT_ITEM_ID, COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID, CAGR_ENTITLEMENT_ID CAGR_ENTITLEMENT_ID, CATEGORY_NAME CATEGORY_NAME, 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, CAGR_ENTITLEMENT_LINE_ID CAGR_ENTITLEMENT_LINE_ID, FREEZE_FLAG FREEZE_FLAG, VALUE VALUE, RANGE_FROM RANGE_FROM, RANGE_TO RANGE_TO, UNITS_OF_MEASURE UNITS_OF_MEASURE, OIPL_ID OIPL_ID, ELIGY_PRFL_ID ELIGY_PRFL_ID, START_DATE START_DATE, END_DATE END_DATE, 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, FORMULA_ID FORMULA_ID, COLUMN_TYPE COLUMN_TYPE, COLUMN_SIZE COLUMN_SIZE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID, MULTIPLE_ENTRIES_ALLOWED_FLAG MULTIPLE_ENTRIES_ALLOWED_FLAG, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PER_CAGR_RETAINED_RIGHTS"

View Text - HTML Formatted

SELECT CAGR_RETAINED_RIGHT_ID CAGR_RETAINED_RIGHT_ID
, CAGR_ENTITLEMENT_RESULT_ID CAGR_ENTITLEMENT_RESULT_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, CAGR_ENTITLEMENT_ITEM_ID CAGR_ENTITLEMENT_ITEM_ID
, COLLECTIVE_AGREEMENT_ID COLLECTIVE_AGREEMENT_ID
, CAGR_ENTITLEMENT_ID CAGR_ENTITLEMENT_ID
, CATEGORY_NAME CATEGORY_NAME
, 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
, CAGR_ENTITLEMENT_LINE_ID CAGR_ENTITLEMENT_LINE_ID
, FREEZE_FLAG FREEZE_FLAG
, VALUE VALUE
, RANGE_FROM RANGE_FROM
, RANGE_TO RANGE_TO
, UNITS_OF_MEASURE UNITS_OF_MEASURE
, OIPL_ID OIPL_ID
, ELIGY_PRFL_ID ELIGY_PRFL_ID
, START_DATE START_DATE
, END_DATE END_DATE
, 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
, FORMULA_ID FORMULA_ID
, COLUMN_TYPE COLUMN_TYPE
, COLUMN_SIZE COLUMN_SIZE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, MULTIPLE_ENTRIES_ALLOWED_FLAG MULTIPLE_ENTRIES_ALLOWED_FLAG
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PER_CAGR_RETAINED_RIGHTS"