APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_BOOKS

Line 127: from fa_books

123: and posting_status = 'MERGED';
124:
125: select l_total_cost + nvl(cost, 0)
126: into l_total_cost
127: from fa_books
128: where book_type_code = px_mass_add_rec.book_type_code
129: and asset_id = px_mass_add_rec.add_to_asset_id
130: and transaction_header_id_out is null;
131: if (l_total_cost > 0) then

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