View: HR_DE_SOCINS_PROV_DEFINITION_V

Product:	PER - Human Resources
Description:	View based on User tables for easy viewing of Social Insurance Provider Information
Implementation/DBA Data:	APPS.HR_DE_SOCINS_PROV_DEFINITION_V

View Text

SELECT HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'PROVIDERNAME')
, HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'PROVIDERTYPE')
, HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'HEALTHINSURANCETYPE')
, HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'EASTBETRIEBESNUMBER')
, HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'WESTBETRIEBESNUMBER')
, HR_DE_GENERAL.GET_UCI(SN.EFFECTIVE_DATE
, UT.USER_TABLE_ID
, UR.USER_ROW_ID
, 'PENSIONINSURANCETYPE')
FROM PAY_USER_TABLES UT
, PAY_USER_ROWS_F UR
, FND_SESSIONS SN
WHERE UT.USER_TABLE_NAME = 'HR_DE_SOC_INS_PROV_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