APPS.FA_CUA_ASSET_WB_APIS_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 451: from fa_methods a, fa_category_book_defaults b

447: is
448: v_dummy varchar2(20);
449: cursor c is
450: select rate_source_rule
451: from fa_methods a, fa_category_book_defaults b
452: where b.category_id = x_cat_id
453: and book_type_code = x_book_type_code
454: and a.method_code = b.deprn_method
455: and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate) ) );

Line 500: from fa_category_book_defaults

496: ,x_err_stack in out nocopy varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
497: is
498: CURSOR C is
499: select prorate_convention_code
500: from fa_category_book_defaults
501: where category_id = x_category_id
502: and book_type_code = x_book
503: and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate)) );
504: l_prorate_convention varchar2(10);