Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_ELEMENT_CLASSIFICATION_V |
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