View: PER_CAGR_ENTITLEMENT_RESULTS_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_CAGR_ENTITLEMENT_RESULTS_V

View Text

SELECT ER.CAGR_ENTITLEMENT_RESULT_ID
, ER.CAGR_REQUEST_ID
, ER.START_DATE
, ER.END_DATE
, ER.COLLECTIVE_AGREEMENT_ID
, CA.NAME
, ER.CAGR_ENTITLEMENT_ITEM_ID
, EI.ITEM_NAME
, ER.ELEMENT_TYPE_ID
, ER.INPUT_VALUE_ID
, ER.CAGR_API_ID
, ER.CAGR_API_PARAM_ID
, ER.CATEGORY_NAME
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_CATEGORIES'
, ER.CATEGORY_NAME)
, 1
, 80)
, ER.CAGR_ENTITLEMENT_ID
, ER.CAGR_ENTITLEMENT_LINE_ID
, ER.ASSIGNMENT_ID
, DECODE(ER.FLEX_VALUE_SET_ID
, NULL
, ER.VALUE
, PER_CAGR_UTILITY_PKG.GET_NAME_FROM_VALUE_SET(ER.FLEX_VALUE_SET_ID
, ER.BUSINESS_GROUP_ID
, ER.VALUE))
, ER.UNITS_OF_MEASURE
, DECODE(ER.UNITS_OF_MEASURE
, NULL
, NULL
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('UNITS'
, ER.UNITS_OF_MEASURE)
, 1
, 80))
, ER.RANGE_FROM
, ER.RANGE_TO
, ER.PARENT_SPINE_ID
, PS.NAME
, ER.GRADE_SPINE_ID
, GS.D_GRADE
, ER.STEP_ID
, SP1.D_SPINAL_POINT
, ER.FROM_STEP_ID
, SP2.D_SPINAL_POINT
, ER.TO_STEP_ID
, SP3.D_SPINAL_POINT
, ER.RETAINED_ENT_RESULT_ID
, DECODE(NVL(CRR.CAGR_RETAINED_RIGHT_ID
, CRR1.CAGR_RETAINED_RIGHT_ID)
, NULL
, 'N'
, 'Y')
, ER.BENEFICIAL_FLAG
, ER.CHOSEN_FLAG
, ER.COLUMN_TYPE
, ER.COLUMN_SIZE
, ER.OIPL_ID
, DECODE(ER.OIPL_ID
, NULL
, FF.FORMULA_NAME
, DECODE(ER.OIPL_ID
, 0
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_DEFAULT'
, 'DEF')
, 1
, 80)
, BEP.NAME))
, DECODE(ER.OIPL_ID
, NULL
, 'F'
, 'C')
, ER.FLEX_VALUE_SET_ID
, ER.OBJECT_VERSION_NUMBER
, NVL(CRR.CAGR_RETAINED_RIGHT_ID
, CRR1.CAGR_RETAINED_RIGHT_ID)
, NVL(CRR.OBJECT_VERSION_NUMBER
, CRR1.OBJECT_VERSION_NUMBER)
, NVL(CRR.FREEZE_FLAG
, CRR1.FREEZE_FLAG)
, NVL(CRR.START_DATE
, CRR1.START_DATE)
, NVL(CRR.END_DATE
, CRR1.END_DATE)
FROM PER_CAGR_ENTITLEMENT_RESULTS ER
, PER_CAGR_ENTITLEMENT_ITEMS EI
, PER_COLLECTIVE_AGREEMENTS CA
, BEN_ELIGY_PRFL_F BEP
, FF_FORMULAS_F FF
, PER_PARENT_SPINES PS
, PER_GRADE_SPINES_V GS
, PER_SPINAL_POINT_STEPS_V SP1
, PER_SPINAL_POINT_STEPS_V SP2
, PER_SPINAL_POINT_STEPS_V SP3
, PER_CAGR_RETAINED_RIGHTS CRR
, PER_CAGR_RETAINED_RIGHTS CRR1
, FND_SESSIONS SES
WHERE ER.CAGR_ENTITLEMENT_ITEM_ID = EI.CAGR_ENTITLEMENT_ITEM_ID
AND ER.COLLECTIVE_AGREEMENT_ID = CA.COLLECTIVE_AGREEMENT_ID
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ER.START_DATE
AND NVL(ER.END_DATE
, HR_GENERAL.END_OF_TIME)
AND ER.ELIGY_PRFL_ID = BEP.ELIGY_PRFL_ID (+)
AND (SES.EFFECTIVE_DATE BETWEEN BEP.EFFECTIVE_START_DATE
AND BEP.EFFECTIVE_END_DATE OR BEP.ELIGY_PRFL_ID IS NULL)
AND ER.FORMULA_ID = FF.FORMULA_ID (+)
AND (SES.EFFECTIVE_DATE BETWEEN FF.EFFECTIVE_START_DATE
AND FF.EFFECTIVE_END_DATE OR FF.FORMULA_ID IS NULL)
AND ER.PARENT_SPINE_ID = PS.PARENT_SPINE_ID (+)
AND ER.GRADE_SPINE_ID = GS.GRADE_SPINE_ID (+)
AND ER.STEP_ID = SP1.STEP_ID (+)
AND ER.FROM_STEP_ID = SP2.STEP_ID (+)
AND ER.TO_STEP_ID = SP3.STEP_ID (+)
AND ER.CAGR_ENTITLEMENT_RESULT_ID = SP3.SPINAL_POINT_ID (+)
AND ER.CAGR_ENTITLEMENT_RESULT_ID = CRR.CAGR_ENTITLEMENT_RESULT_ID (+)
AND ER.RETAINED_ENT_RESULT_ID = CRR1.CAGR_ENTITLEMENT_RESULT_ID (+) ORDER BY ER.CAGR_ENTITLEMENT_RESULT_ID

Columns