APPS.FA_JAPAN_DEP_TAX_SUMMARY_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: 19

  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: 25

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

Line: 29

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

Line: 35

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

Line: 104

    select meaning
      into l_meaning
    from fnd_lookups
    where lookup_type = l_type
      and lookup_code = l_code;

Line: 116

    select meaning
      into l_meaning
    from fa_lookups
    where lookup_type = l_type
      and lookup_code = l_code;

Line: 130

    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 = l_state
      and  DTI.REQUEST_ID = p_request_id;

Line: 157

      select count(1)
        into l_count
      from   FA_DEPRN_TAX_REP_ITF
      where  REQUEST_ID = p_request_id
      and    ASSET_ID IS NOT NULL;