APPS.FA_JAPAN_DEP_TAX_DECREASE_PKG SQL Statements

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

Line: 15

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

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

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

Line: 72

 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 ='D';