Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSBFV_PAY_ELEMENT_DISTRIBUTION |
SELECT PE.NAME
, PEPG.NAME
, PED.DISTRIBUTION_ID
, PED.POSITION_SET_GROUP_ID
, PEPG.PAY_ELEMENT_ID
, PED.EFFECTIVE_START_DATE
, PED.EFFECTIVE_END_DATE
, PED.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, PED.DISTRIBUTION_PERCENT
, PED.DISTRIBUTION_SET_ID
, PED.LAST_UPDATE_DATE
, PED.LAST_UPDATED_BY
, PED.CREATED_BY
, PED.CREATION_DATE
FROM PSB_PAY_ELEMENT_DISTRIBUTIONS PED
, PSB_ELEMENT_POS_SET_GROUPS PEPG
, PSB_PAY_ELEMENTS PE
, GL_CODE_COMBINATIONS_KFV GCC
WHERE PED.POSITION_SET_GROUP_ID = PEPG.POSITION_SET_GROUP_ID
AND PEPG.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID
AND PED.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY