[Home] [Help]
View: PSBFV_POSITION_PAY_DISTRS
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PD.EFFECTIVE_START_DATE
, PD.EFFECTIVE_END_DATE
, '_KF:PSB:BPS:PKFV:_CO'
, '_KF:SQLGL:GL#:GCC'
, PD.DESCRIPTION
, DISTRIBUTION_PERCENT
, PD.DISTRIBUTION_ID
, PD.POSITION_ID
, PD.CODE_COMBINATION_ID
FROM GL_CODE_COMBINATIONS GCC
, PSB_POSITIONS POS
, PSB_POSITION_DEFINITIONS_KFV PKFV
, PSB_POSITION_PAY_DISTRIBUTIONS PD
WHERE PD.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND POS.POSITION_ID = PD.POSITION_ID
AND PKFV.POSITION_DEFINITION_ID = POS.POSITION_DEFINITION_ID WITH READ ONLY
Columns
Name |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
"_KF:POSITION_NAME" |
"_KF:GL_ACCOUNT" |
DESCRIPTION |
SALARY_DISTRIBUTION_PERCENT |
DISTRIBUTION_ID |
POSITION_ID |
CODE_COMBINATION_ID |