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
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
|
|
|