FND Design Data [Home] [Help]

View: PA_ALLOC_BUDGET_TYPES_V

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_ALLOC_BUDGET_TYPES_V
View Text

SELECT BUDGET_TYPE_CODE
, BUDGET_TYPE FROM PA_BUDGET_TYPES
WHERE BUDGET_AMOUNT_CODE = 'C'
AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE))

Columns

Name
BUDGET_TYPE_CODE
BUDGET_TYPE