Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_USER_COLUMN_INSTANCES_V |
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
, 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
FROM PAY_USER_COLUMN_INSTANCES_F PCI
, PAY_USER_ROWS_F PUR
WHERE PCI.USER_ROW_ID = PUR.USER_ROW_ID
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') )