PSPBV_TEMPLATE_AWARDS displays the list of awards selected in the effort report selection criteria template.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT PTA.TEMPLATE_ID , PTA.AWARD_ID , PTA.LAST_UPDATE_DATE , PTA.LAST_UPDATED_BY , PTA.CREATED_BY , PTA.CREATION_DATE FROM PSP_TEMPLATE_AWARDS PTA , PSP_EFFORT_REPORT_TEMPLATES PET , GMS_AWARDS_ALL GAA WHERE PTA.TEMPLATE_ID=PET.TEMPLATE_ID AND PTA.AWARD_ID=GAA.AWARD_ID WITH READ ONLY