Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PEA.APPROVING_PERSON_ID
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PEA.APPROVED_DATE
, PEA.EFFORT_REPORT_ID
, PEA.VERSION_NUM
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.CREATED_BY
, PEA.CREATION_DATE
, PER.VERSION_CREATION_DATE
, PER.MESSAGE_ID
, PER.REPORT_COMMENT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PER.TEMPLATE_ID
, PERT.TEMPLATE_NAME
, PER.PREV_EFFORT_REPORT_ID
FROM PSP_ER_APPROVALS PEA
, PSP_EFFORT_REPORTS PER
, PER_ALL_PEOPLE_F PPF
, PSP_EFFORT_REPORT_TEMPLATES PERT
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)
AND PER.TEMPLATE_ID= PERT.TEMPLATE_ID (+) WITH READ ONLY