PSPBV_TEMPLATE_ORGANIZATIONS displays the list of organization identifiers selected in the effort report selection criteria template.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT PTO.EXPENDITURE_ORGANIZATION_ID , PTO.TEMPLATE_ID , PTO.LAST_UPDATE_DATE , PTO.LAST_UPDATED_BY , PTO.CREATED_BY , PTO.CREATION_DATE FROM PSP_TEMPLATE_ORGANIZATIONS PTO , PSP_EFFORT_REPORT_TEMPLATES PET , HR_ALL_ORGANIZATION_UNITS HOU WHERE PTO.TEMPLATE_ID=PET.TEMPLATE_ID AND PTO.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID AND '_SEC:PTO.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY