VIEW: APPS.PAY_RUN_BALANCE_STATUS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'