[Home] [Help]
View: PSBBV_POSITION_ASSIGNMENTS
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PAS.ELEMENT_VALUE
, '_LA:ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PAS.CURRENCY_CODE
, '_LA:PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING'
, PAS.EFFECTIVE_START_DATE
, PAS.EFFECTIVE_END_DATE
, PAS.POSITION_ID
, PAS.POSITION_ASSIGNMENT_ID
, PAS.WORKSHEET_ID
, PAS.PAY_ELEMENT_ID
, PAS.PAY_ELEMENT_OPTION_ID
FROM PSB_POSITION_ASSIGNMENTS PAS
WHERE PAS.ASSIGNMENT_TYPE = 'ELEMENT'
Columns
| Name |
| ELEMENT_VALUE |
| "_LA:ELEMENT_VALUE_TYPE" |
| CURRENCY_CODE |
| "_LA:PAY_BASIS" |
| START_EFFECTIVE_DATE |
| END_EFFECTIVE_DATE |
| POSITION_ID |
| POSITION_ASSIGNMENT_ID |
| WORKSHEET_ID |
| PAY_ELEMENT_ID |
| PAY_ELEMENT_OPTION_ID |