View: PAY_USER_COLUMN_INSTANCES_FV

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_USER_COLUMN_INSTANCES_FV

View Text

SELECT PCI.ROWID ROW_ID
, PCI.USER_COLUMN_INSTANCE_ID
, PCI.EFFECTIVE_START_DATE
, PCI.EFFECTIVE_END_DATE
, PCI.USER_ROW_ID
, PCI.USER_COLUMN_ID
, PCI.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PCI.LEGISLATION_CODE
, PCI.LEGISLATION_SUBGROUP
, PUR.ROW_LOW_RANGE_OR_NAME
, URT.ROW_LOW_RANGE_OR_NAME
, PUR.ROW_HIGH_RANGE
, PCI.VALUE
, PUR.DISPLAY_SEQUENCE
, PCI.LAST_UPDATE_DATE
, PCI.LAST_UPDATED_BY
, PCI.LAST_UPDATE_LOGIN
, PCI.CREATED_BY
, PCI.CREATION_DATE
, PCI.OBJECT_VERSION_NUMBER
FROM PAY_USER_COLUMN_INSTANCES_F PCI
, PAY_USER_ROWS_F PUR
, PAY_USER_ROWS_F_TL URT
WHERE PCI.USER_ROW_ID = PUR.USER_ROW_ID
AND PCI.USER_ROW_ID = URT.USER_ROW_ID
AND URT.LANGUAGE = USERENV('LANG')
AND PCI.EFFECTIVE_START_DATE <=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND PCI.EFFECTIVE_END_DATE >=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND PUR.EFFECTIVE_START_DATE <=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND PUR.EFFECTIVE_END_DATE >=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )

Columns