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

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

       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.prorate_calendar and
             ct.fiscal_year_name = bc.fiscal_year_name
         and cp.calendar_type = ct.calendar_type and
             ( (cp.start_date >= h_parent_prorate_date and
                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: 273

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

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

Line: 291

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

Line: 297

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

Line: 341

      select FA_METHODS_S.NEXTVAL
      into h_method_id
      from sys.dual;

Line: 376

      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_methodname,
	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: 431

         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);