VIEW: APPS.HR_DE_TAX_OFFICE_DEFINITION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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