[Home] [Help]
View: PSBBV_PAY_ELEMENT_RATES
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, '_LA:PER.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PER.ELEMENT_VALUE
, '_LA:PER.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING'
, PER.MAXIMUM_VALUE
, PER.MID_VALUE
, PER.MINIMUM_VALUE
, PER.CURRENCY_CODE
, PER.PAY_ELEMENT_RATE_ID
, PER.PAY_ELEMENT_OPTION_ID
, PER.WORKSHEET_ID
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATED_BY
, PER.CREATION_DATE
FROM PSB_PAY_ELEMENT_RATES PER WITH READ ONLY
Columns
| Name |
| START_EFFECTIVE_DATE |
| END_EFFECTIVE_DATE |
| "_LA:ELEMENT_VALUE_TYPE" |
| ELEMENT_VALUE |
| "_LA:PAY_BASIS" |
| MAXIMUM_VALUE |
| MID_VALUE |
| MINIMUM_VALUE |
| CURRENCY_CODE |
| PAY_ELEMENT_RATE_ID |
| PAY_ELEMENT_OPTION_ID |
| WORKSHEET_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |