DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_METHODS

Line 9249: from fa_methods fm

9245: --cursor to get method id
9246: cursor l_method_csr1 (p_method_code in varchar2,
9247: p_life in number) is
9248: select fm.method_id
9249: from fa_methods fm
9250: where fm.method_code = p_method_code
9251: and fm.life_in_months = p_life
9252: and fm.life_in_months is not null;
9253:

Line 9258: from fa_methods fm

9254: cursor l_method_csr2 (p_method_code in varchar2,
9255: p_basic_rate in number,
9256: p_adj_rate in number) is
9257: select fm.method_id
9258: from fa_methods fm
9259: where fm.method_code = p_method_code
9260: and fm.life_in_months is null
9261: and exists (select 1
9262: from fa_flat_rates ffr

Line 9267: l_method_id fa_methods.method_id%TYPE;

9263: where ffr.method_id = fm.method_id
9264: and ffr.basic_rate = p_basic_rate
9265: and ffr.adjusted_rate = p_adj_rate);
9266:
9267: l_method_id fa_methods.method_id%TYPE;
9268:
9269: l_rep_pdt_book fa_books.book_type_code%TYPE;
9270:
9271: