[Home] [Help]
View: PAY_DEFINED_BALANCES_LOV
View Text
SELECT BTTL.BALANCE_NAME || BD.DATABASE_ITEM_SUFFIX BALANCE_TYPE_NAME
, BT.BALANCE_TYPE_ID
, SUBSTR(BT.BALANCE_UOM
, 1
, 1) BALANCE_UNITS
, L.MEANING BALANCE_UNITS_MEANING
, DB.DEFINED_BALANCE_ID
, DB.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, BT.CURRENCY_CODE BALANCE_CURRENCY_CODE
, DB.LEGISLATION_CODE
FROM PAY_DEFINED_BALANCES DB
, PAY_BALANCE_TYPES BT
, PAY_BALANCE_TYPES_TL BTTL
, PAY_BALANCE_DIMENSIONS BD
, HR_LOOKUPS L
, FF_ROUTE_CONTEXT_USAGES CU
, FF_CONTEXTS CO
WHERE BT.BALANCE_TYPE_ID = BTTL.BALANCE_TYPE_ID
AND BTTL.LANGUAGE = USERENV('LANG')
AND BT.BALANCE_TYPE_ID = DB.BALANCE_TYPE_ID
AND DB.BALANCE_DIMENSION_ID = BD.BALANCE_DIMENSION_ID
AND SUBSTR(BT.BALANCE_UOM
, 1
, 1) IN ('H'
, 'I'
, 'N'
, 'M')
AND BD.ROUTE_ID = CU.ROUTE_ID
AND CU.CONTEXT_ID = CO.CONTEXT_ID
AND CO.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID'
AND NOT EXISTS (SELECT 1
FROM FF_ROUTE_CONTEXT_USAGES ROU
, FF_CONTEXTS CON
WHERE ROU.ROUTE_ID = BD.ROUTE_ID
AND ROU.CONTEXT_ID = CON.CONTEXT_ID
AND CON.CONTEXT_NAME != 'ASSIGNMENT_ACTION_ID')
AND L.LOOKUP_CODE = BT.BALANCE_UOM
AND L.LOOKUP_TYPE = 'UNITS'
Columns
Name |
BALANCE_TYPE_NAME |
BALANCE_TYPE_ID |
BALANCE_UNITS |
BALANCE_UNITS_MEANING |
DEFINED_BALANCE_ID |
BUSINESS_GROUP_ID |
BALANCE_CURRENCY_CODE |
LEGISLATION_CODE |