[Home] [Help]
23: and a.book_type_code = x_book_type_code ;
24:
25: CURSOR C_get_rule( p_rule_set_level VARCHAR2 ) IS
26: select cua_rule_set_id
27: from fa_category_book_defaults
28: where category_id = x_cat_id_in
29: and book_type_code = x_book_type_code
30: and p_rule_set_level = 'ASSET_CATEGORY'
31: UNION
199: add_months( nvl(v_prorated_depr_date, x_prorate_date), life_in_months),
200: add_months(x_prorate_date, life_in_months) ) life_end_date
201: , life_in_months
202: , 'CORPORATE' book_class
203: from fa_category_book_defaults
204: where category_id = decode(x_rule_det_rec.target_flag, 'Y', x_node_category_id, x_asset_cat_id )
205: and (trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate) ) )
206: and nvl(x_rule_det_rec.include_asset_catg_life_flag, 'N') = 'Y'
207: and book_type_code = x_book_type_code
213: , book_type_code
214: , cua_life_end_date life_end_date
215: , life_in_months
216: , 'CORPORATE' book_class
217: from fa_category_book_defaults
218: where category_id = decode(x_rule_det_rec.target_flag, 'Y', x_node_category_id, x_asset_cat_id )
219: and (trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate) ) )
220: and nvl(x_rule_det_rec.include_catg_end_date_flag, 'N') = 'Y'
221: and book_type_code = x_book_type_code
452: select '1' dummy,
453: deprn_method
454: , prorate_convention_code
455: , life_in_months
456: from fa_category_book_defaults
457: where category_id = p_cat_id
458: and book_type_code = x_book_type_code
459: and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate)) )
460: UNION
461: select '2' dummy
462: , deprn_method
463: , prorate_convention_code
464: , life_in_months
465: from fa_category_book_defaults
466: where category_id = p_cat_id
467: and book_type_code = g_corporate_book
468: and ( trunc(sysdate) between start_dpis and nvl(end_dpis, trunc(sysdate)) )
469: ORDER BY 1;