VIEW: APPS.PER_CAGR_ENTITLEMENT_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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