APPS.FA_DEP_SUMM_TAX_REG_PKG SQL Statements

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

Line: 58

  SELECT fsc.company_name
  INTO   gc_company_name
  FROM 	 fa_system_controls fsc;

Line: 72

  SELECT gl.currency_code
  INTO   gc_currency_code
  FROM 	 fa_book_controls fbc
        ,gl_ledgers       gl
  WHERE  fbc.book_type_code      = P_BOOK
  AND    fbc.set_of_books_id = gl.ledger_id;

Line: 89

  SELECT fsav.application_column_name
        ,fifs.flex_value_set_id
  INTO   gc_major_category
 	,gn_maj_cat_value_set_id
  FROM   fnd_segment_attribute_values fsav
	,fnd_id_flex_segments         fifs
  WHERE  fifs.segment_name    = 'Tax Group'
  --fsav.segment_attribute_type  = 'BASED_CATEGORY'
  AND    fsav.attribute_value         = 'Y'
  AND    fsav.id_flex_code            = 'CAT#'
  AND    fsav.id_flex_num             = 101
  AND	 fifs.application_column_name = fsav.application_column_name
  AND 	 fifs.id_flex_num             = fsav.id_flex_num
  AND    fifs.id_flex_code            = fsav.id_flex_code;

Line: 115

  /*SELECT fsav.application_column_name
  INTO   gc_minor_category
  FROM   fnd_segment_attribute_values fsav
  WHERE  segment_attribute_type = 'MINOR_CATEGORY'
  AND    attribute_value        = 'Y'
  AND    id_flex_code           = 'CAT#';

Line: 123

  SELECT fifs.application_column_name
  INTO   gc_minor_category
  FROM   fnd_id_flex_segments fifs
  WHERE  fifs.segment_name  = 'Asset Type'
  AND    fifs.id_flex_num   = 101
  AND    fifs.id_flex_code  = 'CAT#';

Line: 141

  SELECT fdp.period_counter
        ,NVL(fdp.period_close_date,sysdate)
        ,fdp.fiscal_year
        ,fdp.calendar_period_close_date
  INTO   gn_period_counter
        ,ld_period_close_date
        ,gc_fiscal_year
        ,ld_calender_close_date
  FROM   fa_deprn_periods      fdp
  WHERE  fdp.book_type_code = P_BOOK
  AND    fdp.period_name    = P_PERIOD1;

Line: 172

  SELECT ffy.start_date
  INTO   ld_fiscal_start_date
  FROM   fa_book_controls     fbc
        ,fa_fiscal_year	      ffy
  WHERE  fbc.book_type_code   = P_BOOK
  AND    ffy.fiscal_year      = gc_fiscal_year
  AND    ffy.fiscal_year_name = fbc.fiscal_year_name;