VIEW: APPS.PAY_CA_RB_SUPP_EARNINGS_V

Source

View Text - Preformatted

SELECT pbt.balance_name, pbt.balance_type_id, pbt.business_group_id, pbt.legislation_code, pbtl.balance_name from pay_balance_types pbt, pay_balance_types_tl pbtl, pay_defined_balances pdb, pay_balance_attributes pba, pay_bal_attribute_definitions pad WHERE pad.attribute_name = 'PAY_CA_BPS_SUPP_EARNINGS' and pad.legislation_code = 'CA' and pad.attribute_id = pba.attribute_id and pba.defined_balance_id = pdb.defined_balance_id and pbt.balance_type_id = pdb.balance_type_id and pbtl.balance_type_id = pbt.balance_type_id and pbtl.language = userenv('LANG') and exists (select 'x' from pay_balance_dimensions where balance_dimension_id = pdb.balance_dimension_id and legislation_code = 'CA' AND database_item_suffix = '_ASG_GRE_RUN')

View Text - HTML Formatted

SELECT PBT.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, PBT.BUSINESS_GROUP_ID
, PBT.LEGISLATION_CODE
, PBTL.BALANCE_NAME
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTL
, PAY_DEFINED_BALANCES PDB
, PAY_BALANCE_ATTRIBUTES PBA
, PAY_BAL_ATTRIBUTE_DEFINITIONS PAD
WHERE PAD.ATTRIBUTE_NAME = 'PAY_CA_BPS_SUPP_EARNINGS'
AND PAD.LEGISLATION_CODE = 'CA'
AND PAD.ATTRIBUTE_ID = PBA.ATTRIBUTE_ID
AND PBA.DEFINED_BALANCE_ID = PDB.DEFINED_BALANCE_ID
AND PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
AND PBTL.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBTL.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT 'X'
FROM PAY_BALANCE_DIMENSIONS
WHERE BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
AND LEGISLATION_CODE = 'CA'
AND DATABASE_ITEM_SUFFIX = '_ASG_GRE_RUN')