APPS.FA_CUA_ASSET_APIS dependencies on FA_ASSET_HIERARCHY_VALUES

Line 122: from fa_asset_hierarchy_values

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

Line 134: from fa_asset_hierarchy_values a,

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

Line 428: from fa_asset_hierarchy_values

424: , dist_set_id
425: , asset_key_ccid
426: , serial_number
427: , life_end_date
428: from fa_asset_hierarchy_values
429: where asset_hierarchy_id = p_node_id
430: and book_type_code = x_book_type_code
431: UNION
432: select '2' dummy, asset_hierarchy_id

Line 439: from fa_asset_hierarchy_values

435: , dist_set_id
436: , asset_key_ccid
437: , serial_number
438: , life_end_date
439: from fa_asset_hierarchy_values
440: where asset_hierarchy_id = p_node_id
441: and book_type_code = g_corporate_book
442: order by 1;
443: