APPS.CSE_ASSET_CREATION_PKG dependencies on FA_CATEGORY_BOOKS

Line 690: FROM fa_category_books

686: -- default asset group id
687: BEGIN
688: SELECT default_group_asset_id
689: INTO l_default_group_asset_id
690: FROM fa_category_books
691: WHERE category_id = l_asset_category_id
692: AND book_type_code = l_book_type_code;
693: EXCEPTION
694: WHEN no_data_found THEN

Line 1619: FROM fa_category_books

1615: l_p_mass_add_rec.last_update_login := fnd_global.login_id;
1616:
1617: SELECT default_group_asset_id
1618: INTO l_p_mass_add_rec.group_asset_id
1619: FROM fa_category_books
1620: WHERE category_id = l_p_mass_add_rec.asset_category_id
1621: AND book_type_code = l_p_mass_add_rec.book_type_code;
1622:
1623: l_p_mass_add_rec.parent_mass_addition_id := NULL;

Line 3215: FROM fa_category_books

3211: AND book_type_code = c_book_type_code ;
3212:
3213: CURSOR get_group_asset_id_cur (c_asset_category_id IN NUMBER, c_book_type_code IN VARCHAR2) IS
3214: SELECT default_group_asset_id
3215: FROM fa_category_books
3216: WHERE category_id = c_asset_category_id
3217: AND book_type_code = c_book_type_code ;
3218:
3219: CURSOR prorate_convention_cur (c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS