[Home] [Help]
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
Name |
DEFINED_BALANCE_ID |
STATUS |
LEGISLATION_CODE |
BUSINESS_GROUP_ID |
BALANCE_TYPE_ID |
BALANCE_DIMENSION_ID |
BALANCE_NAME |
DIMENSION_NAME |
DATABASE_ITEM_SUFFIX |