Product: | PER - Human Resources |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PER_CAGR_ENTITLEMENTS_V |
SELECT PCE.CAGR_ENTITLEMENT_ID
, PCE.CAGR_ENTITLEMENT_ITEM_ID
, PCEV.ITEM_NAME
, PCEV.CATEGORY_NAME
, PCEV.CATEGORY_NAME_DESC
, PCEV.BENEFICIAL_RULE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_BENEFICIAL_RULE'
, PCEV.BENEFICIAL_RULE)
, 1
, 80) BENEFICIAL_RULE_DESC
, PCEV.PARAMETER_LOOKUP_TYPE
, PCE.COLLECTIVE_AGREEMENT_ID
, PCA.NAME COLLECTIVE_AGREEMENT_NAME
, PCE.START_DATE
, PCE.END_DATE
, PCE.STATUS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_STATUS'
, PCE.STATUS)
, 1
, 80) STATUS_DESC
, PCE.FORMULA_CRITERIA
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_CRITERIA_TYPE'
, PCE.FORMULA_CRITERIA)
, 1
, 80) FORMULA_CRITERIA_DESC
, PCE.FORMULA_ID
, FF.FORMULA_NAME
, PCE.UNITS_OF_MEASURE
, PCEV.ELEMENT_NAME
, PCEV.ELEMENT_TYPE_ID
, PCEV.INPUT_VALUE_NAME
, PCEV.INPUT_VALUE_ID
, PCEV.UOM_DESC
, PCE.LAST_UPDATE_DATE
, PCE.LAST_UPDATED_BY
, PCE.LAST_UPDATE_LOGIN
, PCE.CREATED_BY
, PCE.CREATION_DATE
, PCE.OBJECT_VERSION_NUMBER
, PCE.MESSAGE_LEVEL
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_MESSAGE_LEVEL'
, PCE.MESSAGE_LEVEL)
, 1
, 80) MESSAGE_LEVEL_DESC
, PCEV.FLEX_VALUE_SET_ID
, PCEV.FLEX_VALUE_SET_NAME
FROM PER_CAGR_ENTITLEMENTS PCE
, PER_CAGR_ENTITLEMENT_ITEMS_V PCEV
, PER_COLLECTIVE_AGREEMENTS PCA
, FF_FORMULAS FF
, FND_SESSIONS FS
WHERE PCEV.CAGR_ENTITLEMENT_ITEM_ID = PCE.CAGR_ENTITLEMENT_ITEM_ID
AND PCA.COLLECTIVE_AGREEMENT_ID = PCE.COLLECTIVE_AGREEMENT_ID
AND FF.FORMULA_ID (+) = PCE.FORMULA_ID
AND FS.EFFECTIVE_DATE BETWEEN PCE.START_DATE
AND NVL(PCE.END_DATE
, HR_GENERAL.END_OF_TIME)
AND FS.SESSION_ID = USERENV('SESSIONID')