View: PAY_GROSSUP_BAL_EXCL_V4

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

View Text

SELECT PBT_TL.BALANCE_TYPE_ID
, PBT_TL.BALANCE_NAME
, PEE.ELEMENT_ENTRY_ID
, GBE.GROSSUP_BALANCES_ID
, GBE.START_DATE
, GBE.END_DATE
, GBE.OBJECT_VERSION_NUMBER
, GBE.SOURCE_TYPE
, DECODE(GBE.SOURCE_TYPE
, 'ET'
, 'Y'
, 'N') EXCLUDE_LEVEL
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBT_TL
, PAY_ELEMENT_ENTRIES_F PEE
, FND_SESSIONS SES
, PAY_GROSSUP_BAL_EXCLUSIONS GBE
WHERE GBE.SOURCE_ID = PEE.ELEMENT_ENTRY_ID
AND GBE.SOURCE_TYPE = 'EE'
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 PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE UNION ALL SELECT PBT_TL.BALANCE_TYPE_ID
, PBT_TL.BALANCE_NAME
, PEE.ELEMENT_ENTRY_ID
, GBE.GROSSUP_BALANCES_ID
, GBE.START_DATE
, GBE.END_DATE
, GBE.OBJECT_VERSION_NUMBER
, GBE.SOURCE_TYPE
, DECODE(GBE.SOURCE_TYPE
, 'ET'
, 'Y'
, 'N') EXCLUDE_LEVEL
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBT_TL
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_GROSSUP_BAL_EXCLUSIONS GBE
, FND_SESSIONS SES
WHERE PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND 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 PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE

Columns