View: PER_CAGR_ENTITLEMENT_LINES_V

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

View Text

SELECT PCL.CAGR_ENTITLEMENT_LINE_ID
, PCL.MANDATORY
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_MANDATORY'
, PCL.MANDATORY)
, 1
, 80) MANDATORY_DESC
, PCL.VALUE
, SUBSTR(PER_CAGR_UTILITY_PKG.GET_NAME_FROM_VALUE_SET(PCL.CAGR_ENTITLEMENT_ID
, PCL.VALUE)
, 1
, 240) VALUE_DESC
, PCL.RANGE_FROM
, SUBSTR(PER_CAGR_UTILITY_PKG.GET_NAME_FROM_VALUE_SET(PCL.CAGR_ENTITLEMENT_ID
, PCL.RANGE_FROM)
, 1
, 240) RANGE_FROM_DESC
, PCL.RANGE_TO
, SUBSTR(PER_CAGR_UTILITY_PKG.GET_NAME_FROM_VALUE_SET(PCL.CAGR_ENTITLEMENT_ID
, PCL.RANGE_TO)
, 1
, 240) RANGE_TO_DESC
, PCL.EFFECTIVE_START_DATE
, PCL.EFFECTIVE_END_DATE
, PCL.GRADE_SPINE_ID
, PGS.D_GRADE GRADE_NAME
, PCL.PARENT_SPINE_ID
, PPS.NAME PARENT_SPINE_NAME
, PCL.CAGR_ENTITLEMENT_ID
, PCL.STATUS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_STATUS'
, PCL.STATUS)
, 1
, 80) STATUS_DESC
, PCL.OIPL_ID
, PCL.ELIGY_PRFL_ID
, DECODE(PCL.ELIGY_PRFL_ID
, 0
, HR_GENERAL.DECODE_LOOKUP('CAGR_DEFAULT'
, 'DEF')
, BEP.NAME) ELIGIBLITY_PROFILE_NAME
, PCL.STEP_ID
, PSPS1.D_SPINAL_POINT SPINAL_POINT
, PCL.FROM_STEP_ID
, PSPS2.D_SPINAL_POINT FROM_SPINAL_POINT
, PCL.TO_STEP_ID
, PSPS3.D_SPINAL_POINT TO_SPINAL_POINT
, PCL.LAST_UPDATE_DATE
, PCL.LAST_UPDATED_BY
, PCL.LAST_UPDATE_LOGIN
, PCL.CREATED_BY
, PCL.CREATION_DATE
, PCL.OBJECT_VERSION_NUMBER
FROM FND_SESSIONS FS
, PER_CAGR_ENTITLEMENT_LINES_F PCL
, PER_GRADE_SPINES_V PGS
, PER_PARENT_SPINES PPS
, PER_SPINAL_POINT_STEPS_V PSPS1
, PER_SPINAL_POINT_STEPS_V PSPS2
, PER_SPINAL_POINT_STEPS_V PSPS3
, BEN_ELIGY_PRFL BEP
WHERE BEP.ELIGY_PRFL_ID (+) = PCL.ELIGY_PRFL_ID
AND PSPS3.STEP_ID (+) = PCL.TO_STEP_ID
AND PSPS2.STEP_ID (+) = PCL.FROM_STEP_ID
AND PSPS1.STEP_ID (+) = PCL.STEP_ID
AND PGS.GRADE_SPINE_ID (+) = PCL.GRADE_SPINE_ID
AND PPS.PARENT_SPINE_ID (+) = PCL.PARENT_SPINE_ID
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PCL.EFFECTIVE_START_DATE
AND PCL.EFFECTIVE_END_DATE

Columns