VIEW: APPS.PAYBV_BALANCE_TYPE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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