APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_ADDITIONS

Line 184: from fa_additions ad, fa_books bk

180: l_asset_id number := 0;
181: begin
182: select ad.asset_id
183: into l_asset_id
184: from fa_additions ad, fa_books bk
185: where asset_key_ccid = px_mass_add_rec.asset_category_id
186: and asset_key_ccid = px_mass_add_rec.ASSET_KEY_CCID
187: and ad.asset_id = bk.asset_id
188: and bk.book_type_code = px_mass_add_rec.book_type_code