Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_USER_COLUMNS_V |
SELECT PUC.ROWID ROW_ID
, PUC.USER_COLUMN_ID
, PUC.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PUC.LEGISLATION_CODE
, PUC.USER_TABLE_ID
, PUC.USER_COLUMN_NAME
, PUC.FORMULA_ID
, FF.FORMULA_NAME
, PUC.LEGISLATION_SUBGROUP
, PUC.LAST_UPDATE_DATE
, PUC.LAST_UPDATED_BY
, PUC.LAST_UPDATE_LOGIN
, PUC.CREATED_BY
, PUC.CREATION_DATE
FROM PAY_USER_COLUMNS PUC
, FF_FORMULAS_F FF
WHERE PUC.FORMULA_ID = FF.FORMULA_ID (+)
AND ( PUC.FORMULA_ID IS NULL OR ( FF.EFFECTIVE_START_DATE <=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') )
AND FF.EFFECTIVE_END_DATE >=(SELECT EFFECTIVE_DATE
FROM FND_SESSIONS
WHERE SESSION_ID = USERENV('SESSIONID') ) ) )