eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PER_BF_BALANCE_TYPES_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_BF_BALANCE_TYPES_V

View Text

SELECT BBT.INTERNAL_NAME
, BBT.DISPLAYED_NAME
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, NVL(BBT.UOM
, PBE.UNITS))
, NVL(BBT.UOM
, PBE.UNITS)
, NVL(BBT.CURRENCY
, PBE.CURRENCY_CODE)
, PBE.ELEMENT_REPORTING_NAME
, PBE.ELEMENT_NAME
, PBE.INPUT_VALUE_NAME
, HR_GENERAL.DECODE_LOOKUP('BACKFEED_BT_CATEGORY'
, BBT.CATEGORY)
, BBT.CATEGORY
, BBT.DATE_FROM
, BBT.DATE_TO
, PBE.INPUT_VALUE_ID
, PBE.ELEMENT_TYPE_ID
, BBT.BALANCE_TYPE_ID
, BBT.BUSINESS_GROUP_ID
, BBT.OBJECT_VERSION_NUMBER
FROM PER_BF_BALANCE_ELEMENTS_V PBE
, PER_BUSINESS_GROUPS BUS
, PER_BF_BALANCE_TYPES BBT
WHERE BUS.BUSINESS_GROUP_ID = BBT.BUSINESS_GROUP_ID
AND BBT.BALANCE_TYPE_ID = PBE.BALANCE_TYPE_ID (+) WITH READ ONLY

Columns

Name
INTERNAL_BALANCE_NAME
DISPLAYED_BALANCE_NAME
UNITS
UNITS_CODE
CURRENCY_CODE
ELEMENT_REPORTING_NAME
ELEMENT_NAME
INPUT_VALUE_NAME
BALANCE_CATEGORY
BALANCE_CATEGORY_CODE
BALANCE_DATE_FROM
BALANCE_DATE_TO
INPUT_VALUE_ID
ELEMENT_TYPE_ID
BALANCE_TYPE_ID
BUSINESS_GROUP_ID
OBJECT_VERSION_NUMBER