VIEW: APPS.PAY_GROSSUP_BAL_EXCL_V4

Source

View Text - Preformatted

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

View Text - HTML Formatted

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