View: HR_DE_TAX_OFFICE_DEFINITION_V

Product:	PER - Human Resources
Description:	View based on User tables for easy viewing of Tax office(recorded as Orgs) Information
Implementation/DBA Data:	APPS.HR_DE_TAX_OFFICE_DEFINITION_V

View Text

SELECT HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'BUNDESLAND')
, HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'TAXOFFICENO')
, HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'TAXOFFICENAME')
FROM PAY_USER_TABLES UT
, PAY_USER_ROWS_F UR
, FND_SESSIONS SN
WHERE UT.USER_TABLE_NAME = 'HR_DE_TAX_OFFICE_DEFINITION'
AND UT.LEGISLATION_CODE = 'DE'
AND UR.USER_TABLE_ID = UT.USER_TABLE_ID
AND SN.SESSION_ID = USERENV('SESSIONID')
AND SN.EFFECTIVE_DATE BETWEEN UR.EFFECTIVE_START_DATE
AND UR.EFFECTIVE_END_DATE

Columns