[Home] [Help]
| Product: | PSP - Labor Distribution |
|---|---|
| Description: | PSPBV_EFFORT_REPORT_TEMPLATES displays the Effort Report selection criteria that can be reused. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PER.TEMPLATE_ID
, PER.TEMPLATE_NAME
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BEGIN_DATE
, PER.PROJECT_TYPE_CLASS_CODE
, PER.PROJECT_TYPE
, PER.END_DATE
, PER.AWARD_TYPE
, PER.FUNDING_SOURCE_ID
, '_LA:ENABLE_WORKFLOW_FLAG:PSP_LOOKUPS:PSP_ENABLE_WORKFLOW_FLAG:MEANING'
, '_LA:USER_TEMPLATE_FLAG:PSP_LOOKUPS:PSP_USER_TEMPLATE_FLAG:MEANING'
, '_LA:REPORT_TYPE:PSP_LOOKUPS:PSP_REPORT_TYPE:MEANING'
, PER.REPORT_INITIATOR_ID
, PER.INITIATOR_APPS_NAME
, PER.ERROR_DATE_TIME
, PER.EFFORT_REPORT_PERIOD_NAME
, PER.PEOPLE_GROUP_ID
, PER.SUPERVISOR_ID
, PER.ELEMENT_TYPE_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PER.TASK_ID
, PER.SET_OF_BOOKS_ID
, PER.BUSINESS_GROUP_ID
, PER.EXPENDITURE_TYPE
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATED_BY
, PER.CREATION_DATE
FROM PSP_EFFORT_REPORT_TEMPLATES PER
, GL_CODE_COMBINATIONS GCC
WHERE PER.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID WITH READ ONLY