eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_CA_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_element_types_f pet, pay_element_classifications pec WHERE pec.classification_name = 'Supplemental Earnings' AND pec.legislation_code = 'CA' AND pec.classification_id = pet.classification_id AND pet.business_group_id = pbt.business_group_id AND pet.element_information10 is not null AND pbt.balance_type_id = pet.element_information10 AND pbtl.balance_type_id = pbt.balance_type_id AND pbtl.language = userenv('LANG')

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_ELEMENT_TYPES_F PET
, PAY_ELEMENT_CLASSIFICATIONS PEC
WHERE PEC.CLASSIFICATION_NAME = 'SUPPLEMENTAL EARNINGS'
AND PEC.LEGISLATION_CODE = 'CA'
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PET.BUSINESS_GROUP_ID = PBT.BUSINESS_GROUP_ID
AND PET.ELEMENT_INFORMATION10 IS NOT NULL
AND PBT.BALANCE_TYPE_ID = PET.ELEMENT_INFORMATION10
AND PBTL.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBTL.LANGUAGE = USERENV('LANG')