95: SELECT decode(ad.asset_type,
96: 'GROUP', 0,
97: bk.cost)
98: INTO h_cost
99: FROM FA_BOOKS_MRC_V bk,
100: FA_ADDITIONS_B ad
101: WHERE ad.asset_id = X_asset_id
102: AND ad.asset_id = bk.asset_id
103: AND bk.book_type_code = X_book_type_code
128: SELECT decode(ad.asset_type,
129: 'GROUP', 0,
130: bk.cost)
131: INTO h_cost
132: FROM FA_BOOKS bk,
133: FA_ADDITIONS_B ad
134: WHERE ad.asset_id = X_asset_id
135: AND ad.asset_id = bk.asset_id
136: AND bk.book_type_code = X_book_type_code