Product: | PSP - Labor Distribution |
---|---|
Description: | PSPFV_CLEARING_ACCOUNTS displays information about the General Ledger clearing account used to charge the payroll costs. |
Implementation/DBA Data: | Not implemented in this database |
SELECT '_KF:SQLGL:GL#:GCC:_CO'
, PCA.COMMENTS
, GCC.CHART_OF_ACCOUNTS_ID
, GCC.ACCOUNT_TYPE
, PCA.SET_OF_BOOKS_ID
, GL.NAME
, PCA.BUSINESS_GROUP_ID
, HR.NAME
, GCC.START_DATE_ACTIVE
, GCC.END_DATE_ACTIVE
, PCA.LAST_UPDATE_DATE
, PCA.LAST_UPDATED_BY
, PCA.CREATED_BY
, PCA.CREATION_DATE
FROM PSP_CLEARING_ACCOUNT PCA
, GL_CODE_COMBINATIONS GCC
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HR
WHERE PCA.REVERSING_GL_CCID = GCC.CODE_COMBINATION_ID
AND PCA.BUSINESS_GROUP_ID=HR.ORGANIZATION_ID
AND PCA.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID WITH READ ONLY