DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_METHODS

Line 9524: from fa_methods fm

9520: --cursor to get method id
9521: cursor l_method_csr1 (p_method_code in varchar2,
9522: p_life in number) is
9523: select fm.method_id
9524: from fa_methods fm
9525: where fm.method_code = p_method_code
9526: and fm.life_in_months = p_life
9527: and fm.life_in_months is not null;
9528:

Line 9533: from fa_methods fm

9529: cursor l_method_csr2 (p_method_code in varchar2,
9530: p_basic_rate in number,
9531: p_adj_rate in number) is
9532: select fm.method_id
9533: from fa_methods fm
9534: where fm.method_code = p_method_code
9535: and fm.life_in_months is null
9536: and exists (select 1
9537: from fa_flat_rates ffr

Line 9542: l_method_id fa_methods.method_id%TYPE;

9538: where ffr.method_id = fm.method_id
9539: and ffr.basic_rate = p_basic_rate
9540: and ffr.adjusted_rate = p_adj_rate);
9541:
9542: l_method_id fa_methods.method_id%TYPE;
9543:
9544: l_rep_pdt_book fa_books.book_type_code%TYPE;
9545:
9546: