DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FA_CATEGORY_BOOKS

Line 710: FROM fa_category_books

706: -- default asset group id
707: BEGIN
708: SELECT default_group_asset_id
709: INTO l_default_group_asset_id
710: FROM fa_category_books
711: WHERE category_id = l_asset_category_id
712: AND book_type_code = l_book_type_code;
713: EXCEPTION
714: WHEN no_data_found THEN

Line 1693: FROM fa_category_books

1689: END IF;
1690:
1691: SELECT default_group_asset_id
1692: INTO l_p_mass_add_rec.group_asset_id
1693: FROM fa_category_books
1694: WHERE category_id = l_p_mass_add_rec.asset_category_id
1695: AND book_type_code = l_p_mass_add_rec.book_type_code;
1696:
1697: l_p_mass_add_rec.parent_mass_addition_id := NULL;

Line 3551: FROM fa_category_books

3547: AND book_type_code = c_book_type_code ;
3548:
3549: CURSOR get_group_asset_id_cur (c_asset_category_id IN NUMBER, c_book_type_code IN VARCHAR2) IS
3550: SELECT default_group_asset_id
3551: FROM fa_category_books
3552: WHERE category_id = c_asset_category_id
3553: AND book_type_code = c_book_type_code ;
3554:
3555: CURSOR prorate_convention_cur (c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS