APPS.FV_BE_PKG4 SQL Statements

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

Line: 14

      SELECT BUDGET_LEVEL_NUM, POST_FLAG
      FROM FV_BUDGET_LEVELS
      WHERE FV_BUDGET_LEVELS.SET_OF_BOOKS_ID = x_set_of_books_id
      ORDER BY BUDGET_LEVEL_NUM
      FOR UPDATE OF BUDGET_LEVEL_ID;

Line: 32

      UPDATE FV_BUDGET_LEVELS
        SET BUDGET_LEVEL_ID =  v_sequence,
            POST_FLAG = DECODE(v_sequence, 1, 'Y', 2, 'Y', v_post_flag)
        WHERE CURRENT OF C;

Line: 63

      select  description
	into    x_description
	from    fv_budget_levels
	where budget_level_id = x_budget_level_id
	and   set_of_books_id = x_set_of_bks_id ;

Line: 90

               select   description
               into     x_trans_description
               from     fv_be_transaction_types
               where    apprn_transaction_type = x_transaction_type
               and      set_of_books_id        = x_set_of_bks_id;

Line: 116

	SELECT USER_NAME
      INTO x_user_name
      FROM FND_USER
      WHERE FND_USER.USER_ID = x_user_id;

Line: 141

	select description
	into x_description
	from fv_lookup_codes
	where lookup_code = x_resource_type and
		lookup_type = x_lookup_type;

Line: 162

  select fvbl.description
  from fv_budget_levels fvbl
  where fvbl.set_of_books_id = P_SET_OF_BKS_ID
  and not exists (
                select glc.je_category_name
		from gl_je_categories glc
		where glc.je_category_name = fvbl.description);