View: PAY_USER_COLUMN_INSTANCES_D

Product:	PAY - Payroll
Description:	Used by Datetrack History
Implementation/DBA Data:	APPS.PAY_USER_COLUMN_INSTANCES_D

View Text

SELECT UC.USER_COLUMN_INSTANCE_ID
, UC.EFFECTIVE_START_DATE
, UC.EFFECTIVE_END_DATE
, UR.ROW_LOW_RANGE_OR_NAME
, UR.ROW_HIGH_RANGE
, UC.VALUE
, UC.LAST_UPDATE_DATE
, FU.USER_NAME
FROM PAY_USER_ROWS_F UR
, PAY_USER_COLUMN_INSTANCES_F UC
, FND_USER FU
WHERE UC.USER_ROW_ID = UR.USER_ROW_ID
AND UC.EFFECTIVE_START_DATE BETWEEN UR.EFFECTIVE_START_DATE
AND UR.EFFECTIVE_END_DATE
AND FU.USER_ID (+)= UC.LAST_UPDATED_BY

Columns