APPS.FARX_C_WD SQL Statements

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

Line: 196

  select count(*) into h_count
  from fa_book_controls
  where book_Type_code = argument1 and rownum < 2;

Line: 215

  select mrc_sob_type_code,currency_code
  into FARX_C_WD.mrc_sob_type,FARX_C_WD.currency
  from gl_sets_of_books
  where set_of_books_id = to_number(argument20);

Line: 241

  select count(*) into h_count
  from fa_book_controls bc, fa_calendar_periods cp
  where bc.book_type_code = argument1
  and bc.deprn_calendar = cp.calendar_type
  and cp.period_name = argument2 and rownum < 2;

Line: 275

  select count(*) into h_count
  from fa_book_controls bc, fa_calendar_types ct,
  fa_calendar_periods cp
  where bc.book_type_code = argument1
  and bc.deprn_calendar = ct.calendar_type
  and ct.calendar_type = cp.calendar_type
  and cp.start_date >= (select cp1.start_date from
	fa_calendar_periods cp1
	where cp1.calendar_type = cp.calendar_type
	and cp1.period_name = argument2);

Line: 329

      select category_flex_structure into h_cat_struct
              from fa_system_controls;

Line: 366

       select count(*) into h_count from fa_categories cat,
                                         fa_category_books cb
       where cat.category_id = h_cat_id
       and cat.enabled_flag = 'Y' and cat.capitalize_flag = 'YES'
       and sysdate between nvl(cat.start_date_active,sysdate-1) and
	   nvl(cat.end_date_active,sysdate+1)
       and cat.category_id = cb.category_id
       and cb.book_type_code = argument1 and rownum < 2;

Line: 440

  select count(*) into h_count
  from fa_methods
  where method_code = argument11 and rownum < 2;

Line: 465

  select count(*) into h_count from fa_methods
  where method_code = argument11
  and rate_source_rule in ('TABLE','CALCULATED','FORMULA')
  and rownum < 2;

Line: 483

    select count(*) into h_count from fa_methods
    where method_code = argument11 and life_in_months = to_number(argument12)
	and rownum < 2;

Line: 515

  select count(*) into h_count from fa_methods m
  where m.method_code = argument11
  and m.rate_source_rule = 'FLAT' and rownum < 2;

Line: 533

    select count(*) into h_count from fa_methods m, fa_flat_rates r
    where m.method_code = argument11
    and m.method_id = r.method_id
    and r.adjusted_rate = h_adj_rate and rownum < 2;

Line: 572

  select count(*) into h_count from fa_conventions
  where prorate_convention_code = argument14 and rownum < 2;

Line: 636

  select count(*) into h_count from fnd_user
  where user_id = to_number(argument17) and rownum < 2;

Line: 674

  select count(*) into h_count from fa_bonus_rules
  where bonus_rule = argument19 and rownum < 2;

Line: 774

       fa_whatif_deprn_pkg.g_deprn.delete;

Line: 792

       select category_flex_structure into h_cat_struct
              from fa_system_controls;

Line: 830

       select count(*) into h_count from fa_categories cat,
                                         fa_category_books cb
       where cat.category_id = h_cat_id
       and cat.enabled_flag = 'Y' and cat.capitalize_flag = 'YES'
       and sysdate between nvl(cat.start_date_active,sysdate-1) and
	   nvl(cat.end_date_active,sysdate+1)
       and cat.category_id = cb.category_id
       and cb.book_type_code = argument1 and rownum < 2;

Line: 880

  fa_whatif_deprn_pkg.g_deprn.delete;