PSPBV_TEMPLATE_PROJECTS displays the list of projects selected in the effort report selection criteria template.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT PTP.PROJECT_ID , PTP.TEMPLATE_ID , PTP.LAST_UPDATE_DATE , PTP.LAST_UPDATED_BY , PTP.CREATED_BY , PTP.CREATION_DATE FROM PSP_TEMPLATE_PROJECTS PTP , PSP_EFFORT_REPORT_TEMPLATES PET , PA_PROJECTS_ALL PPA WHERE PTP.TEMPLATE_ID=PET.TEMPLATE_ID AND PTP.PROJECT_ID=PPA.PROJECT_ID WITH READ ONLY