View: PA_PROJECT_STATUS_LOV_V

Product:	PA - Projects
Description:	This view displays all the valid project status codes - Retrofitted
Implementation/DBA Data:	APPS.PA_PROJECT_STATUS_LOV_V

View Text

SELECT PROJECT_STATUS_CODE
, PROJECT_STATUS_NAME
FROM PA_PROJECT_STATUSES
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND STATUS_TYPE = 'PROJECT'

Columns