VIEW: APPS.PAY_BALANCE_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT pba.rowid ,pba.balance_attribute_id ,pba.attribute_id ,bad.attribute_name ,pba.defined_balance_id ,pdb.balance_type_id ,dim.balance_dimension_id ,dim.dimension_name ,pba.legislation_code ,pba.business_group_id ,bad.user_attribute_name ,pba.last_update_date ,pba.last_updated_by ,pba.last_update_login ,pba.created_by ,pba.creation_date from pay_balance_attributes pba , pay_bal_attribute_definitions bad , pay_defined_balances pdb , pay_balance_dimensions dim where pba.attribute_id = bad.attribute_id and pba.defined_balance_id = pdb.defined_balance_id and pdb.balance_dimension_id = dim.balance_dimension_id

View Text - HTML Formatted

SELECT PBA.ROWID
, PBA.BALANCE_ATTRIBUTE_ID
, PBA.ATTRIBUTE_ID
, BAD.ATTRIBUTE_NAME
, PBA.DEFINED_BALANCE_ID
, PDB.BALANCE_TYPE_ID
, DIM.BALANCE_DIMENSION_ID
, DIM.DIMENSION_NAME
, PBA.LEGISLATION_CODE
, PBA.BUSINESS_GROUP_ID
, BAD.USER_ATTRIBUTE_NAME
, PBA.LAST_UPDATE_DATE
, PBA.LAST_UPDATED_BY
, PBA.LAST_UPDATE_LOGIN
, PBA.CREATED_BY
, PBA.CREATION_DATE
FROM PAY_BALANCE_ATTRIBUTES PBA
, PAY_BAL_ATTRIBUTE_DEFINITIONS BAD
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_DIMENSIONS DIM
WHERE PBA.ATTRIBUTE_ID = BAD.ATTRIBUTE_ID
AND PBA.DEFINED_BALANCE_ID = PDB.DEFINED_BALANCE_ID
AND PDB.BALANCE_DIMENSION_ID = DIM.BALANCE_DIMENSION_ID