APPS.FA_CAPITALIZE_CIP_PKG1 SQL Statements

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

Line: 17

      SELECT DISTINCT RATE_SOURCE_RULE
      FROM FA_METHODS
      WHERE METHOD_CODE	= h_deprn_method;

Line: 24

      select nvl(life_in_months,0), nvl(minimum_life_in_months,0),
	     subcomponent_life_rule,
	     deprn_method --Bug	9746253
      from fa_category_book_defaults
      where book_type_code = X_book
	and category_id	= X_cat_id
	and X_dpis
	    between start_dpis
	    and	nvl(end_dpis,add_months(sysdate,1200));

Line: 40

      select nvl(life_in_months,0), nvl(life_in_months,0),
	     prorate_date
      from fa_books
      where book_type_code = X_book
	and asset_id = X_parent_asset_id
	and date_ineffective is	null;

Line: 54

       select round
	      (nvl(sum
	       (decode (bc.deprn_allocation_code,'E',
		1/ct.number_per_fiscal_year,
		(cp.end_date + 1 - cp.start_date) /
		(fy.end_date + 1 - fy.start_date))),0) * 12, 0)
       from fa_calendar_periods	cp,
	    fa_calendar_types ct,
	    fa_book_controls bc,
	    fa_fiscal_year fy
       where bc.book_type_code = X_book	and
	     bc.date_ineffective is null and
	     ct.calendar_type =	bc.deprn_calendar and
	     ct.fiscal_year_name = bc.fiscal_year_name
	 and cp.calendar_type =	ct.calendar_type and
	     ( (cp.end_date >= h_parent_prorate_date and  -- Bug 16355508
		cp.end_date <  h_prorate_date) )
	 and fy.fiscal_year_name = bc.fiscal_year_name
	 and fy.start_date <= cp.start_date
	 and fy.end_date >= cp.end_date;

Line: 244

	select name
	into h_method_name
	from fa_methods
	where method_code = h_deprn_method
	and life_in_months = h_parent_life ;

Line: 303

      select method_id,
	     depreciate_lastyear_flag,
	     rate_source_rule,
	     deprn_basis_rule,
	     stl_method_flag,
	     exclude_salvage_value_flag
      from fa_methods
      where method_code	= p_deprn_method
	and nvl(life_in_months,0) = p_lim;

Line: 314

	select method_code, life_in_months
	from fa_methods
	where method_code = h_deprn_method
	and nvl(life_in_months,0) = h_lim;

Line: 321

	select name
	from fa_methods
	where method_code = h_deprn_method
	order by created_by desc;

Line: 327

   SELECT formula_actual,
	  formula_displayed,
	  formula_parsed
     FROM FA_FORMULAS
    WHERE method_id = p_method_id;

Line: 371

      select FA_METHODS_S.NEXTVAL
      into h_method_id
      from sys.dual;

Line: 406

      FA_METHODS_PKG.Insert_Row(
	X_Rowid			   => h_rowid,
	X_Method_Id		   => h_method_id,
	X_Method_Code		   => h_deprn_method,
	X_Life_In_Months	   => h_lim,
	X_Depreciate_Lastyear_Flag => h_deprn_last_year_flag, -- 'YES',
	X_STL_Method_Flag	   => h_stl_method_flag,      -- 'YES',
	X_Rate_Source_Rule	   => h_rsr,		      -- 'CALCULATED',
	X_Deprn_Basis_Rule	   => h_deprn_basis_rule,     -- 'COST',
	X_Prorate_Periods_Per_Year => NULL,
	X_Name			   => h_method_name,
	X_Last_Update_Date	   => X_curr_date,
	X_Last_Updated_By	   => X_user_id,
	X_Created_By		   => X_user_id,
	X_Creation_Date		   => X_curr_date,
	X_Last_Update_Login	   => -1,
	X_Attribute1		   => null,
	X_Attribute2		   => null,
	X_Attribute3		   => null,
	X_Attribute4		   => null,
	X_Attribute5		   => null,
	X_Attribute6		   => null,
	X_Attribute7		   => null,
	X_Attribute8		   => null,
	X_Attribute9		   => null,
	X_Attribute10		   => null,
	X_Attribute11		   => null,
	X_Attribute12		   => null,
	X_Attribute13		   => null,
	X_Attribute14		   => null,
	X_Attribute15		   => null,
	X_Attribute_Category_Code  => null,
	X_Exclude_Salvage_Value_Flag =>	h_exclude_sal_flag,
	X_Calling_Fn		   => 'fa_capitalize_cip_pkg1.check_life',
	p_log_level_rec		   => p_log_level_rec);

Line: 461

	 FA_FORMULAS_PKG.insert_row
	      (X_ROWID		     =>	h_rowid,
	       X_METHOD_ID	     =>	h_method_id,
	       X_FORMULA_ACTUAL	     =>	h_formula_actual,
	       X_FORMULA_DISPLAYED   =>	h_formula_displayed,
	       X_FORMULA_PARSED	     =>	h_formula_parsed,
	       X_CREATION_DATE	     =>	X_curr_date,
	       X_CREATED_BY	     =>	X_user_id,
	       X_LAST_UPDATE_DATE    =>	X_curr_date,
	       X_LAST_UPDATED_BY     =>	X_user_id,
	       X_LAST_UPDATE_LOGIN   =>	-1,
	       p_log_level_rec	     =>	p_log_level_rec);