APPS.FA_RECLASS_PUB dependencies on FA_BOOKS

Line 57: FROM fa_books bks,

53: l_calling_fn varchar2(40) := 'FA_RECLASS_PUB.do_reclass';
54:
55: CURSOR C_corp_book( p_asset_id number ) IS
56: SELECT bc.book_type_code
57: FROM fa_books bks,
58: fa_book_controls bc
59: WHERE bks.book_type_code = bc.distribution_source_book
60: AND bks.book_type_code = bc.book_type_code
61: AND bks.asset_id = p_asset_id

Line 135: from fa_books b

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