APPS.FA_DELETION_PUB dependencies on FA_BOOKS

Line 45: from fa_books

41: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) IS
42:
43: CURSOR c_tax_books IS
44: select distinct book_type_code
45: from fa_books
46: where asset_id = px_asset_hdr_rec.asset_id
47: /*code fix for bug no.3768406.Changed the field from date_effective to date_ineffective*/
48: and date_ineffective is null;
49:

Line 114: from fa_books bk,

110: if (px_asset_hdr_rec.book_type_code is null) then
111:
112: select bk.book_type_code
113: into px_asset_hdr_rec.book_type_code
114: from fa_books bk,
115: fa_book_controls bc
116: where bk.asset_id = px_asset_hdr_rec.asset_id
117: and bk.date_ineffective is null
118: and bk.book_type_code = bc.book_type_code

Line 373: DELETE FROM FA_BOOKS

369: DELETE FROM FA_ADJUSTMENTS
370: WHERE Asset_Id = px_asset_hdr_rec.asset_id
371: AND book_Type_Code = px_asset_hdr_rec.book_type_code;
372:
373: DELETE FROM FA_BOOKS
374: WHERE Asset_Id = px_asset_hdr_rec.asset_id
375: AND book_Type_Code = px_asset_hdr_rec.book_type_code;
376:
377: DELETE FROM FA_DEPRN_DETAIL