DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_METHODS

Line 1728: l_method_name fa_methods.name%type;

1724: l_method_id number;
1725: l_rowid rowid;
1726:
1727: l_method_id_old number;
1728: l_method_name fa_methods.name%type;
1729: l_deprn_basis_rule varchar2(4);
1730: l_stl_method_flag varchar2(3);
1731: l_dep_last_year_flag varchar2(3);
1732: l_exclude_sal_flag varchar2(3);

Line 1754: FROM FA_METHODS

1750: deprn_basis_rule,
1751: depreciate_lastyear_flag,
1752: stl_method_flag,
1753: exclude_salvage_value_flag
1754: FROM FA_METHODS
1755: WHERE METHOD_CODE = p_deprn_method
1756: AND LIFE_IN_MONTHS = p_life_in_months;
1757:
1758: CURSOR C_FORMULA (p_method_id number) IS

Line 1796: select FA_METHODS_S.NEXTVAL

1792: end if;
1793:
1794: else -- not table
1795:
1796: select FA_METHODS_S.NEXTVAL
1797: into l_method_id
1798: from sys.dual;
1799:
1800: -- need to derive more values to distinguish between

Line 1833: FA_METHODS_PKG.Insert_Row(

1829: if (p_log_level_rec.statement_level) then
1830: fa_debug_pkg.add(l_calling_fn, 'inserting', 'new method');
1831: end if;
1832:
1833: FA_METHODS_PKG.Insert_Row(
1834: X_Rowid => l_rowid,
1835: X_Method_Id => l_method_id,
1836: X_Method_Code => p_deprn_method,
1837: X_Life_In_Months => p_lim,

Line 2301: fa_methods mt

2297: and (bk.rate_Adjustment_factor <> 1 OR
2298: (bk.rate_adjustment_factor = 1 and
2299: exists (select 'YES' -- and amortized before.
2300: from fa_transaction_headers th,
2301: fa_methods mt
2302: where th.book_type_code = bk.book_type_code
2303: and th.asset_id = bk.asset_id
2304: and th.transaction_type_code = 'ADJUSTMENT'
2305: and (th.transaction_subtype = 'AMORTIZED' OR th.transaction_key = 'UA')