DBA Data[Home] [Help]

APPS.IGI_IAC_COMMON_UTILS dependencies on FA_BOOKS

Line 316: FROM fa_books b, fa_retirements r

312: l_path_name := g_path||'get_cost_retirement_factor';
313:
314: SELECT b.cost, r.cost_retired
315: INTO l_cost, l_cost_retired
316: FROM fa_books b, fa_retirements r
317: WHERE b.book_type_code = P_book_type_Code
318: AND b.asset_id = P_asset_id
319: AND r.retirement_id = P_retirement_id
320: AND r.retirement_id = b.retirement_id ;

Line 505: FROM fa_books b

501: l_path_name := g_path||'get_cy_py_factors';
502:
503: SELECT b.date_placed_in_service
504: INTO l_dpis
505: FROM fa_books b
506: WHERE b.book_type_code = P_book_type_code
507: AND b.asset_id = P_Asset_Id
508: AND b.date_ineffective IS NULL ;
509:

Line 802: from fa_books fb ,

798: X_asset_id IN Varchar2,
799: X_Period_Counter OUT NOCOPY Varchar2 ) RETURN BOOLEAN IS
800:
801: Cursor C1 is select date_placed_in_service
802: from fa_books fb ,
803: igi_iac_book_controls ibc
804: Where fb.book_type_code = ibc.book_type_code
805: AND fb.book_type_code = X_book_type_code
806: AND fb.asset_id = X_asset_id