VIEW: APPS.PA_ALLOC_BUDGET_ENTRY_METHOD_V

Source

View Text - Preformatted

SELECT budget_entry_method_code ,budget_entry_method ,entry_level_code ,categorization_code ,cost_quantity_flag ,raw_cost_flag ,burdened_cost_flag ,time_phased_type_code FROM pa_budget_entry_methods WHERE ((cost_quantity_flag = 'Y') OR (raw_cost_flag = 'Y') OR (burdened_cost_flag = 'Y')) AND trunc(sysdate) between trunc(start_date_active) and trunc(nvl(end_date_active,sysdate))

View Text - HTML Formatted

SELECT BUDGET_ENTRY_METHOD_CODE
, BUDGET_ENTRY_METHOD
, ENTRY_LEVEL_CODE
, CATEGORIZATION_CODE
, COST_QUANTITY_FLAG
, RAW_COST_FLAG
, BURDENED_COST_FLAG
, TIME_PHASED_TYPE_CODE
FROM PA_BUDGET_ENTRY_METHODS
WHERE ((COST_QUANTITY_FLAG = 'Y') OR (RAW_COST_FLAG = 'Y') OR (BURDENED_COST_FLAG = 'Y'))
AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE))