View: PAY_GROSSUP_BAL_EXCL_V3

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_GROSSUP_BAL_EXCL_V3

View Text

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

Columns