PSPBV_EFFORT_REPORT_APPROVALS displays the person who certifies a given Effort Report.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT PEA.APPROVING_PERSON_ID , PEA.APPROVED_DATE , PEA.EFFORT_REPORT_ID , PEA.VERSION_NUM , PEA.LAST_UPDATE_DATE , PEA.LAST_UPDATED_BY , PEA.CREATED_BY , PEA.CREATION_DATE FROM PSP_ER_APPROVALS PEA , PSP_EFFORT_REPORTS PER , PER_ALL_PEOPLE_F PPF WHERE PEA.EFFORT_REPORT_ID=PER.EFFORT_REPORT_ID AND PEA.VERSION_NUM=PER.VERSION_NUM AND (PEA.APPROVING_PERSON_ID = PPF.PERSON_ID AND PER.VERSION_CREATION_DATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE) WITH READ ONLY