FND Design Data [Home] [Help]

View: PA_BUDGET_STATUS_CODES_V

Product: PA - Projects
Description: This view displays the valid status codes for budgets
Implementation/DBA Data: ViewAPPS.PA_BUDGET_STATUS_CODES_V
View Text

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

Columns

Name
CODE
NAME