DBA Data[Home] [Help]

APPS.PAY_EBRA_DIAGNOSTICS dependencies on PAY_DEFINED_BALANCES

Line 679: pay_defined_balances pdb, pay_balance_types pbt

675: , decode(pbv.run_balance_status, 'I', null
676: ,to_char(pbv.balance_load_date,'yyyy/mm/dd')) balance_load_date
677: ,nvl(hl.meaning, hl2.meaning) Status
678: FROM
679: pay_defined_balances pdb, pay_balance_types pbt
680: , pay_balance_dimensions pbd
681: , per_business_groups pbg, hr_lookups hl
682: , pay_balance_validation pbv
683: , hr_lookups hl2

Line 747: , PAY_DEFINED_BALANCES PDB

743: ,DIM.DIMENSION_NAME
744: FROM
745: PAY_BALANCE_DIMENSIONS DIM
746: , PAY_BALANCE_TYPES PBT
747: , PAY_DEFINED_BALANCES PDB
748: , PAY_BALANCE_ATTRIBUTES PBA
749: WHERE
750: PBA.attribute_id = cp_attribute_id
751: and PBA.defined_balance_id = PDB.defined_balance_id

Line 781: , PAY_DEFINED_BALANCES PDB

777: ,PDB.save_run_balance
778: FROM
779: PAY_BALANCE_ATTRIBUTES PBA
780: , PAY_BAL_ATTRIBUTE_DEFINITIONS BAD
781: , PAY_DEFINED_BALANCES PDB
782: , PAY_BALANCE_TYPES PBT
783: , PAY_BALANCE_DIMENSIONS DIM
784: Where pba.attribute_id = bad.attribute_id
785: and pba.defined_balance_id = pdb.defined_balance_id