View: GMS_BUDGET_CHANGE_REASON_V

Product:	GMS - Grants Accounting
Description:	This view displays all the valid reason codes that can be specified when a budget is changed.
Implementation/DBA Data:	APPS.GMS_BUDGET_CHANGE_REASON_V

View Text

SELECT LOOKUP_CODE
, MEANING
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'BUDGET CHANGE REASON'
AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns