DBA Data[Home] [Help]

APPS.IGW_EXP_CATEGORIES_V_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

      SELECT description
      INTO v_description
      FROM pa_expenditure_categories
      WHERE expenditure_category = p_expenditure_category;
Line: 33

      SELECT start_date_active
      INTO v_start_date_active
      FROM pa_expenditure_categories
      WHERE expenditure_category = p_expenditure_category;
Line: 54

      SELECT end_date_active
      INTO v_end_date_active
      FROM pa_expenditure_categories
      WHERE expenditure_category = p_expenditure_category;