DBA Data[Home] [Help]

APPS.FA_ADDITION_PVT dependencies on FA_METHODS

Line 62: fa_methods mth,

58: cbd.member_rollup_flag
59: FROM
60: fa_categories cat,
61: fa_category_book_defaults cbd,
62: fa_methods mth,
63: fa_deprn_periods dp,
64: fa_deprn_basis_rules dbr
65: WHERE
66: dp.book_type_code = c_book_type_code and

Line 101: from fa_methods mt,fa_deprn_basis_rules dbr

97: and period_close_date is null;
98:
99: cursor c_get_method_info(c_method_code varchar2) is
100: select rate_source_rule,rule_name
101: from fa_methods mt,fa_deprn_basis_rules dbr
102: where mt.method_code = c_method_code
103: and mt.deprn_basis_rule_id = dbr.deprn_basis_rule_id(+);
104:
105: l_trx_date date;

Line 2252: from fa_methods mt,

2248: -- Fix for Bug #6334489. Do not allow addition of asset with
2249: -- revised rate.
2250: select count(*)
2251: into l_revised_count
2252: from fa_methods mt,
2253: fa_formulas f
2254: where mt.method_code = p_asset_fin_rec.deprn_method_code
2255: and mt.life_in_months = p_asset_fin_rec.life_in_months
2256: and mt.method_id = f.method_id