[Home] [Help]
View: PAY_PAYNZBAL_VALUES_V
View Text
SELECT DISTINCT PAA.ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID
, PBT.BALANCE_TYPE_ID
, PBT.BALANCE_NAME
, PDB.DEFINED_BALANCE_ID
, PBD.DATABASE_ITEM_SUFFIX
, HR_NZBAL.CALC_ALL_BALANCES( PAA.ASSIGNMENT_ACTION_ID
, PDB.DEFINED_BALANCE_ID ) VALUE
FROM PAY_BALANCE_TYPES PBT
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS PBD
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE (PBT.LEGISLATION_CODE IS NULL OR PBT.LEGISLATION_CODE = 'NZ')
AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
AND NOT (PBD.DIMENSION_NAME LIKE '%ELEMENT%')
Columns
Name |
ASSIGNMENT_ID |
ASSIGNMENT_ACTION_ID |
BALANCE_TYPE_ID |
BALANCE_NAME |
DEFINED_BALANCE_ID |
DATABASE_ITEM_SUFFIX |
VALUE |