APPS.FA_CUA_ASSET_APIS dependencies on FA_BOOK_CONTROLS

Line 133: fa_book_controls bc

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

Line 483: from fa_book_controls

479: where asset_id = x_asset_id;
480:
481: CURSOR C_book_class IS
482: select book_class
483: from fa_book_controls
484: where book_type_code = x_book_type_code;
485:
486: CURSOR c_corp_book IS
487: select distribution_source_book

Line 488: from fa_book_controls

484: where book_type_code = x_book_type_code;
485:
486: CURSOR c_corp_book IS
487: select distribution_source_book
488: from fa_book_controls
489: where book_type_code = x_book_type_code;
490:
491: v_top_attr_val_rec C_get_attr_values%ROWTYPE:= NULL;
492: v_lowest_attr_val_rec C_get_attr_values%ROWTYPE:= NULL;

Line 1268: from fa_book_controls

1264: v_book_class VARCHAR2(15);
1265:
1266: CURSOR c_book IS
1267: select book_class
1268: from fa_book_controls
1269: where book_type_code = x_book_type_code;
1270:
1271: BEGIN
1272: x_err_code := '0';

Line 1718: from fa_book_controls

1714: , x_err_stack IN OUT NOCOPY VARCHAR2 ) IS
1715:
1716: CURSOR c_books IS
1717: select book_type_code
1718: from fa_book_controls
1719: where ( (book_type_code = x_book_type_code)
1720: OR (distribution_source_book = x_book_type_code) )
1721: and book_class IN ( 'CORPORATE', 'TAX')
1722: order by book_class;