Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBBV_PAY_ELEMENT_DISTRIBUTION |
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