APPS.FA_CUA_ASSET_APIS dependencies on FA_BOOK_CONTROLS

Line 136: fa_book_controls bc

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
139: and a.book_type_code in (x_book_type_code,g_corporate_book)
140: and b.asset_hierarchy_id in (select x_top_node_id

Line 487: from fa_book_controls

483: where asset_id = x_asset_id;
484:
485: CURSOR C_book_class IS
486: select book_class
487: from fa_book_controls
488: where book_type_code = x_book_type_code;
489:
490: CURSOR c_corp_book IS
491: select distribution_source_book

Line 492: from fa_book_controls

488: where book_type_code = x_book_type_code;
489:
490: CURSOR c_corp_book IS
491: select distribution_source_book
492: from fa_book_controls
493: where book_type_code = x_book_type_code;
494:
495: v_top_attr_val_rec C_get_attr_values%ROWTYPE:= NULL;
496: v_lowest_attr_val_rec C_get_attr_values%ROWTYPE:= NULL;

Line 1275: from fa_book_controls

1271: v_book_class VARCHAR2(15);
1272:
1273: CURSOR c_book IS
1274: select book_class
1275: from fa_book_controls
1276: where book_type_code = x_book_type_code;
1277:
1278: BEGIN
1279: x_err_code := '0';

Line 1733: from fa_book_controls

1729: , x_err_stack IN OUT NOCOPY VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1730:
1731: CURSOR c_books IS
1732: select book_type_code
1733: from fa_book_controls
1734: where ( (book_type_code = x_book_type_code)
1735: OR (distribution_source_book = x_book_type_code) )
1736: and book_class IN ( 'CORPORATE', 'TAX')
1737: order by book_class;