PSPBV_BUSINESS_MANAGERS displays information about the business managers who are in charge of the effort certification process.
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 , PER_ALL_PEOPLE_F PPF , PSP_EFFORT_REPORTS PER WHERE PEA.APPROVING_PERSON_ID = PPF.PERSON_ID AND ( PEA.APPROVED_DATE BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE ) AND PEA.EFFORT_REPORT_ID= PER.EFFORT_REPORT_ID AND PEA.VERSION_NUM =PER.VERSION_NUM WITH READ ONLY