Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_BALANCE_TYPE |
SELECT PBTT.BALANCE_NAME
, PBTT.REPORTING_NAME
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, PBT.BALANCE_UOM) BALANCE_UOM
, PBT.CURRENCY_CODE
, PBT.LEGISLATION_CODE
, PBT.LEGISLATION_SUBGROUP
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PBT.ASSIGNMENT_REMUNERATION_FLAG) ASSIGNMENT_REMUNERATION_FLAG
, PBT.COMMENTS
, PBT.JURISDICTION_LEVEL
, HR_BIS.BIS_DECODE_LOOKUP('US_TAX_TYPE'
, PBT.TAX_TYPE) TAX_TYPE
, '_DF:PAY:PAY_BALANCE_TYPES:PBT'
, PBT.ATTRIBUTE_CATEGORY
, PBT.ATTRIBUTE1
, PBT.ATTRIBUTE2
, PBT.ATTRIBUTE3
, PBT.ATTRIBUTE4
, PBT.ATTRIBUTE5
, PBT.ATTRIBUTE6
, PBT.ATTRIBUTE7
, PBT.ATTRIBUTE8
, PBT.ATTRIBUTE9
, PBT.ATTRIBUTE10
, PBT.ATTRIBUTE11
, PBT.ATTRIBUTE12
, PBT.ATTRIBUTE13
, PBT.ATTRIBUTE14
, PBT.ATTRIBUTE15
, PBT.ATTRIBUTE16
, PBT.ATTRIBUTE17
, PBT.ATTRIBUTE18
, PBT.ATTRIBUTE19
, PBT.ATTRIBUTE20
, PBT.BALANCE_UOM BALANCE_UOM_CODE
, PBT.ASSIGNMENT_REMUNERATION_FLAG ASG_REMUNERATION_FLAG_CODE
, PBT.TAX_TYPE TAX_TYPE_CODE
, PBT.BALANCE_TYPE_ID
, PBT.BUSINESS_GROUP_ID
, PBT.BALANCE_CATEGORY_ID
, PBT.BASE_BALANCE_TYPE_ID
, PBT.INPUT_VALUE_ID
, PBT.LAST_UPDATE_DATE
, PBT.LAST_UPDATED_BY
, PBT.LAST_UPDATE_LOGIN
, PBT.CREATED_BY
, PBT.CREATION_DATE
, PBT.OBJECT_VERSION_NUMBER
, CASE WHEN ((PBT.BUSINESS_GROUP_ID IS NULL
AND PBT.LEGISLATION_CODE IS NULL) OR (PBT.BUSINESS_GROUP_ID IS NULL
AND PBT.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PBT.LEGISLATION_CODE)) OR (PBT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBT.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTT
WHERE PBT.BALANCE_TYPE_ID = PBTT.BALANCE_TYPE_ID
AND PBTT.LANGUAGE = USERENV('LANG') WITH READ ONLY