APPS.FA_DET_ADD_PKG dependencies on FA_BOOK_CONTROLS

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 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;

Line 182: | Added a join to fa_book_controls to insure that we |

178: -- syoung: do the following check if called from single reclass only.
179:
180: /*******************************************************+
181: | Bug 1544755. |
182: | Added a join to fa_book_controls to insure that we |
183: | don't include disabled books. |
184: +*******************************************************/
185:
186: if (X_Calling_Fn = 'FA_ASSET_VAL.Validate_Reclass') then

Line 190: fa_book_controls fbc

186: if (X_Calling_Fn = 'FA_ASSET_VAL.Validate_Reclass') then
187: select count(1)
188: into lv_count
189: from fa_retirements fr,
190: fa_book_controls fbc
191: where fr.book_type_code = fbc.book_type_code
192: and fbc.date_ineffective is null
193: and fr.asset_id = X_Asset_Id
194: and fr.status in ('PENDING', 'REINSTATE', 'PARTIAL')