DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on FA_BOOKS

Line 293: FROM fa_books b, fa_retirements r

289: l_path_name := g_path||'get_cost_retirement_factor';
290:
291: SELECT b.cost, r.cost_retired
292: INTO l_cost, l_cost_retired
293: FROM fa_books b, fa_retirements r
294: WHERE b.book_type_code = P_book_type_Code
295: AND b.asset_id = P_asset_id
296: AND r.retirement_id = P_retirement_id
297: AND r.retirement_id = b.retirement_id ;

Line 477: FROM fa_books b

473: l_path_name := g_path||'get_cy_py_factors';
474:
475: SELECT b.date_placed_in_service
476: INTO l_dpis
477: FROM fa_books b
478: WHERE b.book_type_code = P_book_type_code
479: AND b.asset_id = P_Asset_Id
480: AND b.date_ineffective IS NULL ;
481:

Line 772: from fa_books fb ,

768: X_asset_id IN Varchar2,
769: X_Period_Counter OUT NOCOPY Varchar2 ) RETURN BOOLEAN IS
770:
771: Cursor C1 is select date_placed_in_service
772: from fa_books fb ,
773: igi_iac_book_controls ibc
774: Where fb.book_type_code = ibc.book_type_code
775: AND fb.book_type_code = X_book_type_code
776: AND fb.asset_id = X_asset_id