View: PAYFV_DEFINED_BALANCES

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYFV_DEFINED_BALANCES

View Text

SELECT /* $HEADER: PAYZZVEWDIC00033.LDT 120.3 2008/01/31 13:54:09 SEMANI NOSHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, NVL(DBL.LEGISLATION_CODE
, PBG.LEGISLATION_CODE) LEGISLATION_CODE
, BLT.BALANCE_NAME BALANCE_NAME
, BLT.LEGISLATION_SUBGROUP BALANCE_LEGISLATION_SUBGROUP
, BLT.REPORTING_NAME BALANCE_REPORTING_NAME
, HR_GENERAL.DECODE_LOOKUP('UNITS'
, BLT.BALANCE_UOM) BALANCE_UNIT_OF_MEASURE
, BDM.DIMENSION_NAME DIMENSION_NAME
, HR_GENERAL.DECODE_LOOKUP('DIMENSION_TYPE'
, BDM.DIMENSION_TYPE) DIMENSION_TYPE
, BDM.DESCRIPTION DIMENSION_DESCRIPTION
, BDM.DATABASE_ITEM_SUFFIX DATABASE_ITEM_SUFFIX /* DESCRIPTIVE FLEXFIELDS */
, '_DF:PAY:PAY_BALANCE_TYPES:BLT' /* IDS */
, DBL.DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, DBL.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DBL.BALANCE_TYPE_ID BALANCE_TYPE_ID
, DBL.BALANCE_DIMENSION_ID BALANCE_DIMENSION_ID
FROM PAY_DEFINED_BALANCES DBL
, PAY_BALANCE_TYPES BLT
, PAY_BALANCE_DIMENSIONS BDM
, PER_BUSINESS_GROUPS PBG
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE DBL.BALANCE_TYPE_ID = BLT.BALANCE_TYPE_ID
AND DBL.BALANCE_DIMENSION_ID = BDM.BALANCE_DIMENSION_ID
AND BGRT.ORGANIZATION_ID (+) = DBL.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE (+) = USERENV('LANG')
AND PBG.BUSINESS_GROUP_ID (+) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, DBL.BUSINESS_GROUP_ID)
AND ( (DBL.BUSINESS_GROUP_ID IS NOT NULL
AND DBL.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, DBL.BUSINESS_GROUP_ID)) OR (DBL.LEGISLATION_CODE IS NOT NULL
AND DBL.LEGISLATION_CODE = NVL(PBG.LEGISLATION_CODE
, DBL.LEGISLATION_CODE)) OR (DBL.BUSINESS_GROUP_ID IS NULL
AND DBL.LEGISLATION_CODE IS NULL) ) WITH READ ONLY

Columns