APPS.FA_CUA_ASSET_APIS dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 29: from fa_category_book_defaults

25: and a.book_type_code = x_book_type_code ;
26:
27: CURSOR C_get_rule( p_rule_set_level VARCHAR2 ) IS
28: select cua_rule_set_id
29: from fa_category_book_defaults
30: where category_id = x_cat_id_in
31: and book_type_code = x_book_type_code
32: and p_rule_set_level = 'ASSET_CATEGORY'
33: UNION

Line 206: from fa_category_book_defaults

202: add_months( nvl(v_prorated_depr_date, x_prorate_date), life_in_months),
203: add_months(x_prorate_date, life_in_months) ) life_end_date
204: , life_in_months
205: , 'CORPORATE' book_class
206: from fa_category_book_defaults
207: where category_id = decode(x_rule_det_rec.target_flag, 'Y', x_node_category_id, x_asset_cat_id )
208: and (trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate) ) )
209: and nvl(x_rule_det_rec.include_asset_catg_life_flag, 'N') = 'Y'
210: and book_type_code = x_book_type_code

Line 220: from fa_category_book_defaults

216: , book_type_code
217: , cua_life_end_date life_end_date
218: , life_in_months
219: , 'CORPORATE' book_class
220: from fa_category_book_defaults
221: where category_id = decode(x_rule_det_rec.target_flag, 'Y', x_node_category_id, x_asset_cat_id )
222: and (trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate) ) )
223: and nvl(x_rule_det_rec.include_catg_end_date_flag, 'N') = 'Y'
224: and book_type_code = x_book_type_code

Line 460: from fa_category_book_defaults

456: select '1' dummy,
457: deprn_method
458: , prorate_convention_code
459: , life_in_months
460: from fa_category_book_defaults
461: where category_id = p_cat_id
462: and book_type_code = x_book_type_code
463: and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate)) )
464: UNION

Line 469: from fa_category_book_defaults

465: select '2' dummy
466: , deprn_method
467: , prorate_convention_code
468: , life_in_months
469: from fa_category_book_defaults
470: where category_id = p_cat_id
471: and book_type_code = g_corporate_book
472: and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate)) )
473: ORDER BY 1;