APPS.FA_FASMAINT_XMLP_PKG SQL Statements

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

Line: 28

  delete from fa_maint_rep_itf
  where request_id = C_request_id;

Line: 39

  SELECT SC.Company_Name INTO l_company_name
  FROM FA_SYSTEM_CONTROLS SC;

Line: 57

    select sob.currency_code,
           cur.precision
    into l_currency_code,
     	 l_precision
    from fa_book_controls bc,
         gl_sets_of_books sob,
         fnd_currencies cur
    where bc.book_type_code = P_BOOK
    and   sob.set_of_books_id = bc.set_of_books_id
    and   cur.currency_code = sob.currency_code;

Line: 90

	 function Do_InsertFormula return number is
   h_retcode  number;

Line: 95

	FARX_C_MT.do_insert(P_BOOK,
			    P_event_name,
			    P_maint_date_from,
			    P_maint_date_to,
			    P_asset_number_from,
			    P_asset_number_to,
			    P_dpis_from,
			    P_dpis_to,
			    P_Category_id,
			    P_CONC_REQUEST_ID,
			     h_retcode);