APPS.FA_CUA_ASSET_APIS dependencies on FA_ASSET_HIERARCHY_VALUES

Line 119: from fa_asset_hierarchy_values

115: v_life_end_date date;
116:
117: Cursor check_tax_record_exists (c_asset_hierarchy_id number) is
118: select life_end_date
119: from fa_asset_hierarchy_values
120: where book_type_code = x_book_type_code
121: and asset_hierarchy_id = c_asset_hierarchy_id ;
122:
123: CURSOR C_get_lifes IS

Line 131: from fa_asset_hierarchy_values a,

127: , a.book_type_code book_type_code
128: , a.life_end_date life_end_date
129: , 0 life_in_months
130: , bc.book_class book_class
131: from fa_asset_hierarchy_values a,
132: fa_asset_hierarchy b,
133: fa_book_controls bc
134: where a.asset_hierarchy_id = b.asset_hierarchy_id
135: and bc.book_type_code = a.book_type_code

Line 424: from fa_asset_hierarchy_values

420: , dist_set_id
421: , asset_key_ccid
422: , serial_number
423: , life_end_date
424: from fa_asset_hierarchy_values
425: where asset_hierarchy_id = p_node_id
426: and book_type_code = x_book_type_code
427: UNION
428: select '2' dummy, asset_hierarchy_id

Line 435: from fa_asset_hierarchy_values

431: , dist_set_id
432: , asset_key_ccid
433: , serial_number
434: , life_end_date
435: from fa_asset_hierarchy_values
436: where asset_hierarchy_id = p_node_id
437: and book_type_code = g_corporate_book
438: order by 1;
439: