VIEW: APPS.PA_BUDGET_TYPES_V

Source

View Text - Preformatted

SELECT BUDGET_TYPE_CODE , BUDGET_TYPE , DESCRIPTION , BUDGET_AMOUNT_CODE , PREDEFINED_FLAG , ACCUMULATION_FLAG FROM PA_BUDGET_TYPES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE)) UNION SELECT NAME ,NAME ,DESCRIPTION ,'DEFAULT' ,PRE_DEFINED_FLAG ,NULL FROM PA_FIN_PLAN_TYPES_VL WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))

View Text - HTML Formatted

SELECT BUDGET_TYPE_CODE
, BUDGET_TYPE
, DESCRIPTION
, BUDGET_AMOUNT_CODE
, PREDEFINED_FLAG
, ACCUMULATION_FLAG
FROM PA_BUDGET_TYPES
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE)) UNION SELECT NAME
, NAME
, DESCRIPTION
, 'DEFAULT'
, PRE_DEFINED_FLAG
, NULL
FROM PA_FIN_PLAN_TYPES_VL
WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))