VIEW: APPS.PAYBV_ELEMENT_CLASSIFICATION_V

Source

View Text - Preformatted

SELECT PEC.CLASSIFICATION_NAME ,PEC.DESCRIPTION ,hr_bis.bis_decode_lookup('YES_NO', PEC.COSTABLE_FLAG) COSTABLE_FLAG_M ,hr_bis.bis_decode_lookup('DEBIT_CREDIT', PEC.COSTING_DEBIT_OR_CREDIT) COSTING_DEBIT_OR_CREDIT_M ,hr_bis.bis_decode_lookup('YES_NO', PEC.DISTRIBUTABLE_OVER_FLAG) DISTRIBUTABLE_OVER_FLAG_M ,hr_bis.bis_decode_lookup('YES_NO', PEC.NON_PAYMENTS_FLAG) NON_PAYMENTS_FLAG_M ,hr_bis.bis_decode_lookup('YES_NO', PEC.CREATE_BY_DEFAULT_FLAG) CREATE_BY_DEFAULT_FLAG_M ,hr_bis.bis_decode_lookup('YES_NO', PEC.BALANCE_INITIALIZATION_FLAG) BALANCE_INITIALIZATION_FLAG_M ,PEC.DEFAULT_HIGH_PRIORITY ,PEC.DEFAULT_LOW_PRIORITY ,PEC.DEFAULT_PRIORITY ,PEC.COSTABLE_FLAG ,PEC.COSTING_DEBIT_OR_CREDIT ,PEC.DISTRIBUTABLE_OVER_FLAG ,PEC.NON_PAYMENTS_FLAG ,PEC.CREATE_BY_DEFAULT_FLAG ,PEC.BALANCE_INITIALIZATION_FLAG ,PEC.FREQ_RULE_ENABLED ,PEC.LEGISLATION_SUBGROUP ,PEC.LEGISLATION_CODE ,PEC.BUSINESS_GROUP_ID ,PEC.CLASSIFICATION_ID ,PEC.PARENT_CLASSIFICATION_ID ,PEC.OBJECT_VERSION_NUMBER ,PEC.LAST_UPDATE_DATE ,PEC.LAST_UPDATED_BY ,PEC.LAST_UPDATE_LOGIN ,PEC.CREATED_BY ,PEC.CREATION_DATE ,CASE WHEN ((PEC.BUSINESS_GROUP_ID IS NULL AND PEC.LEGISLATION_CODE IS NULL) OR (PEC.BUSINESS_GROUP_ID IS NULL AND PEC.LEGISLATION_CODE = NVL(hr_bis.get_legislation_code,PEC.LEGISLATION_CODE)) OR (PEC.BUSINESS_GROUP_ID= NVL(hr_bis.get_sec_profile_bg_id, PEC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PAY_ELEMENT_CLASSIFICATIONS_VL PEC WITH READ ONLY

View Text - HTML Formatted

SELECT PEC.CLASSIFICATION_NAME
, PEC.DESCRIPTION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEC.COSTABLE_FLAG) COSTABLE_FLAG_M
, HR_BIS.BIS_DECODE_LOOKUP('DEBIT_CREDIT'
, PEC.COSTING_DEBIT_OR_CREDIT) COSTING_DEBIT_OR_CREDIT_M
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEC.DISTRIBUTABLE_OVER_FLAG) DISTRIBUTABLE_OVER_FLAG_M
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEC.NON_PAYMENTS_FLAG) NON_PAYMENTS_FLAG_M
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEC.CREATE_BY_DEFAULT_FLAG) CREATE_BY_DEFAULT_FLAG_M
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEC.BALANCE_INITIALIZATION_FLAG) BALANCE_INITIALIZATION_FLAG_M
, PEC.DEFAULT_HIGH_PRIORITY
, PEC.DEFAULT_LOW_PRIORITY
, PEC.DEFAULT_PRIORITY
, PEC.COSTABLE_FLAG
, PEC.COSTING_DEBIT_OR_CREDIT
, PEC.DISTRIBUTABLE_OVER_FLAG
, PEC.NON_PAYMENTS_FLAG
, PEC.CREATE_BY_DEFAULT_FLAG
, PEC.BALANCE_INITIALIZATION_FLAG
, PEC.FREQ_RULE_ENABLED
, PEC.LEGISLATION_SUBGROUP
, PEC.LEGISLATION_CODE
, PEC.BUSINESS_GROUP_ID
, PEC.CLASSIFICATION_ID
, PEC.PARENT_CLASSIFICATION_ID
, PEC.OBJECT_VERSION_NUMBER
, PEC.LAST_UPDATE_DATE
, PEC.LAST_UPDATED_BY
, PEC.LAST_UPDATE_LOGIN
, PEC.CREATED_BY
, PEC.CREATION_DATE
, CASE WHEN ((PEC.BUSINESS_GROUP_ID IS NULL
AND PEC.LEGISLATION_CODE IS NULL) OR (PEC.BUSINESS_GROUP_ID IS NULL
AND PEC.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PEC.LEGISLATION_CODE)) OR (PEC.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_ELEMENT_CLASSIFICATIONS_VL PEC WITH READ ONLY