APPS.FA_RECLASS_PUB dependencies on FA_BOOKS

Line 52: FROM fa_books bks,

48: l_calling_fn varchar2(40) := 'FA_RECLASS_PUB.do_reclass';
49:
50: CURSOR C_corp_book( p_asset_id number ) IS
51: SELECT bc.book_type_code
52: FROM fa_books bks,
53: fa_book_controls bc
54: WHERE bks.book_type_code = bc.distribution_source_book
55: AND bks.book_type_code = bc.book_type_code
56: AND bks.asset_id = p_asset_id

Line 132: from fa_books b

128: l_err_stage:= 'check that asset is valid';
129: -- -- dbms_output.put_line(l_err_stage);
130: select count(book_type_code)
131: into l_num_dummy
132: from fa_books b
133: where asset_id = px_asset_hdr_rec.asset_id
134: and date_ineffective is null;
135: if l_num_dummy = 0 then
136: fa_srvr_msg.add_message(