DBA Data[Home] [Help]

APPS.PAY_EBRA_DIAGNOSTICS dependencies on PAY_BALANCE_DIMENSIONS

Line 680: , pay_balance_dimensions pbd

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
684: WHERE pdb.balance_type_id = pbt.balance_type_id

Line 745: PAY_BALANCE_DIMENSIONS DIM

741: SELECT
742: PBT.balance_name
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

Line 783: , PAY_BALANCE_DIMENSIONS DIM

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
786: and pdb.balance_type_id = pbt.balance_type_id
787: and pdb.balance_dimension_id = dim.balance_dimension_id