View: PAY_RUN_BALANCE_STATUS_V

Product:	PAY - Payroll
Description:	Holds details about defined balances that are marked to store run balances
Implementation/DBA Data:	APPS.PAY_RUN_BALANCE_STATUS_V

View Text

SELECT PDB.DEFINED_BALANCE_ID
, NVL(HL.MEANING
, HL2.MEANING) STATUS
, PDB.LEGISLATION_CODE
, PDB.BUSINESS_GROUP_ID
, PBT.BALANCE_TYPE_ID
, PBD.BALANCE_DIMENSION_ID
, PBT.BALANCE_NAME
, PBD.DIMENSION_NAME
, PBD.DATABASE_ITEM_SUFFIX
FROM PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_TYPES PBT
, PAY_BALANCE_DIMENSIONS PBD
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
, PAY_BALANCE_VALIDATION PBV
WHERE PDB.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID
AND PDB.SAVE_RUN_BALANCE = 'Y'
AND HL.LOOKUP_TYPE (+) = 'RUN_BALANCE_STATUS'
AND HL.LOOKUP_CODE (+) = PBV.RUN_BALANCE_STATUS
AND PBV.DEFINED_BALANCE_ID (+) = PDB.DEFINED_BALANCE_ID
AND HL2.LOOKUP_TYPE = 'RUN_BALANCE_STATUS'
AND HL2.LOOKUP_CODE = 'I'

Columns