VIEW: APPS.PER_CAGR_ENTITLEMENTS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')