[Home] [Help]
View: PSBBV_PAY_ELEMENT_DISTRIBUTION
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PED.EFFECTIVE_START_DATE
, PED.EFFECTIVE_END_DATE
, '_KF:SQLGL:GL#:GCC'
, PED.DISTRIBUTION_PERCENT
, PED.DISTRIBUTION_ID
, PED.POSITION_SET_GROUP_ID
, PED.CODE_COMBINATION_ID
, PED.DISTRIBUTION_SET_ID
, PED.LAST_UPDATE_DATE
, PED.LAST_UPDATED_BY
, PED.CREATED_BY
, PED.CREATION_DATE
FROM PSB_PAY_ELEMENT_DISTRIBUTIONS PED
, GL_CODE_COMBINATIONS GCC
WHERE PED.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY
Columns
Name |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
"_KF:GL_ACCOUNT" |
DISTRIBUTION_PERCENT |
DISTRIBUTION_ID |
POSITION_SET_GROUP_ID |
CODE_COMBINATION_ID |
DISTRIBUTION_SET_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |