View: PER_CAGR_ENTITLEMENT_LINES_D

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

View Text

SELECT PCL.CAGR_ENTITLEMENT_LINE_ID
, PCL.EFFECTIVE_START_DATE
, PCL.EFFECTIVE_END_DATE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_MANDATORY'
, PCL.MANDATORY)
, 1
, 80) MANDATORY_DESC
, PCL.VALUE
, PCL.RANGE_FROM
, PCL.RANGE_TO
, PGS.D_GRADE GRADE_NAME
, PPS.NAME PARENT_SPINE_NAME
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_STATUS'
, PCL.STATUS)
, 1
, 80) STATUS_DESC
, PRFL.NAME ELIGIBLITY_PROFILE_NAME
, PSPS1.D_SPINAL_POINT SPINAL_POINT
, PSPS2.D_SPINAL_POINT FROM_SPINAL_POINT
, PSPS3.D_SPINAL_POINT TO_SPINAL_POINT
, PCL.LAST_UPDATE_DATE
, USR.USER_NAME LAST_UPDATED_BY
FROM FND_USER USR
, 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_PRTN_ELIG_V BPE
, BEN_PRTN_ELIG_PRFL_V BPEF
, BEN_ELIGY_PRFL_V PRFL
WHERE PRFL.ELIGY_PRFL_ID (+) = BPEF.ELIGY_PRFL_ID
AND BPEF.PRTN_ELIG_ID (+) = BPE.PRTN_ELIG_ID
AND BPE.OIPL_ID (+) = PCL.OIPL_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_ID (+) = PCL.GRADE_SPINE_ID
AND PPS.PARENT_SPINE_ID (+) = PCL.PARENT_SPINE_ID
AND USR.USER_ID (+) = PCL.LAST_UPDATED_BY

Columns