APPS.FA_JAPAN_DEP_TAX_ADDITION_PKG SQL Statements

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

Line: 8

  Select
	SC.Location_flex_structure,
	SOB.Currency_code
  into	h_loc_flex_struct,
	CURRENCY_CODE
  from	FA_SYSTEM_CONTROLS	SC,
	FA_BOOK_CONTROLS	BC,
	GL_SETS_OF_BOOKS	SOB
  where	BC.BOOK_TYPE_CODE = P_BOOK
  and	SOB.Set_of_books_id = BC.Set_of_books_ID;

Line: 20

  select meaning
  into 	h_classification
  from 	FA_LOOKUPS
  where lookup_type ='JP_CLASSIFICATION'
    and	lookup_code = p_classification;

Line: 39

  select meaning
    into h_imperial_code
  from   FA_LOOKUPS
  where  lookup_type ='JP_IMPERIAL'
    and  lookup_code = to_char(to_date(to_char(p_year),'YYYY'),'E','nls_calendar=''Japanese Imperial''');

Line: 45

  select to_number(to_char(to_date(to_char(p_year),'YYYY'),'YY','nls_calendar=''Japanese Imperial'''))
  into   h_imperial_year
  from dual;

Line: 94

	select	sum(theoretical_nbv), sum(evaluated_nbv)
	into	c_sum_theoretical_nbv, c_sum_evaluated_nbv
	from 	FA_DEPRN_TAX_REP_ITF DTI
	where	DTI.END_COST >0
	and	DTI.STATE = sum_state
	and 	DTI.REQUEST_ID = p_request_id;

Line: 120

  select count(asset_id)
  into c_count
  from FA_DEPRN_TAX_REP_ITF
  where request_id = p_request_id
  and year =p_year
  and state = sum_state
  and add_dec_flag='A';

Line: 127

 else   select count(asset_id)
  into c_count
  from FA_DEPRN_TAX_REP_ITF
  where request_id = p_request_id
  and year =p_year
  and state = sum_state
  and end_cost >0;