8: PDB.DEFINED_BALANCE_ID
9: FROM
10: PAY_BALANCE_DIMENSIONS PBD,
11: PAY_BALANCE_TYPES PBT,
12: PAY_DEFINED_BALANCES PDB
13: WHERE PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
14: AND PBT.BALANCE_NAME = L_BALANCE_NAME
15: AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
16: AND PBD.DATABASE_ITEM_SUFFIX = '_ASG_TWO_YTD'