APPS.FA_DET_ADD_PKG dependencies on FA_BOOKS

Line 17: FROM FA_BOOKS BK, FA_BOOK_CONTROLS BC

13: lv_corp_book varchar2(15);
14: BEGIN
15: SELECT BK.Period_Counter_Fully_Retired,BC.Book_Type_Code
16: INTO X_PC_Fully_Ret, lv_corp_book
17: FROM FA_BOOKS BK, FA_BOOK_CONTROLS BC
18: WHERE BK.Asset_Id = X_Asset_Id
19: AND BK.Date_Ineffective IS NULL
20: AND BK.Book_Type_Code = BC.Book_Type_Code
21: AND BC.Book_Class = 'CORPORATE';

Line 52: from fa_books

48: and book_type_code = lv_corp_book
49: and deprn_source_code = 'BOOKS';
50:
51: select cost into X_Books_Cost
52: from fa_books
53: where asset_id = X_Asset_Id
54: and book_type_code = lv_corp_book
55: and date_ineffective is null;
56: --

Line 93: from fa_books bk, fa_book_controls bc

89: validation_error exception;
90: BEGIN
91: -- find corporate book
92: select bc.book_type_code into lv_corp_book
93: from fa_books bk, fa_book_controls bc
94: where bc.book_class = 'CORPORATE'
95: and bk.asset_id = X_Asset_Id
96: and bk.book_type_code = bc.book_type_code
97: and bk.date_ineffective is null;