VIEW: APPS.PER_CAGR_ENTITLEMENT_LINES_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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