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_GROSSUP_BAL_EXCL_V3

Source

View Text - Preformatted


SELECT pbt_tl.balance_type_id, pbt_tl.balance_name, pet.element_type_id, gbe.grossup_balances_id, gbe.start_date, gbe.end_date, gbe.object_version_number from pay_balance_types pbt, pay_balance_types_tl pbt_tl, pay_element_types_f pet, fnd_sessions ses, pay_grossup_bal_exclusions gbe where gbe.source_id = pet.element_type_id and gbe.source_type = 'ET' and gbe.balance_type_id = pbt.balance_type_id and pbt.balance_type_id = pbt_tl.balance_type_id and pbt_tl.language = USERENV('LANG') and ses.session_id = USERENV('sessionid') and ses.effective_date between pet.effective_start_date and pet.effective_end_date

View Text - HTML Formatted

SELECT PBT_TL.BALANCE_TYPE_ID
, PBT_TL.BALANCE_NAME
, PET.ELEMENT_TYPE_ID
, GBE.GROSSUP_BALANCES_ID
, GBE.START_DATE
, GBE.END_DATE
, GBE.OBJECT_VERSION_NUMBER
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBT_TL
, PAY_ELEMENT_TYPES_F PET
, FND_SESSIONS SES
, PAY_GROSSUP_BAL_EXCLUSIONS GBE
WHERE GBE.SOURCE_ID = PET.ELEMENT_TYPE_ID
AND GBE.SOURCE_TYPE = 'ET'
AND GBE.BALANCE_TYPE_ID = PBT.BALANCE_TYPE_ID
AND PBT.BALANCE_TYPE_ID = PBT_TL.BALANCE_TYPE_ID
AND PBT_TL.LANGUAGE = USERENV('LANG')
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE