APPS.IGIRX_IMP_IAC_REP dependencies on FA_BOOKS

Line 498: FROM fa_books bk,

494: ad.Tag_number,
495: ad.serial_number ,
496: bk.date_placed_in_service ,
497: bk.deprn_method_code
498: FROM fa_books bk,
499: fa_additions ad
500: WHERE ad.asset_id=p_asset_id AND
501: ad.asset_id = bk.asset_id AND
502: bk.transaction_header_id_out is NULL AND

Line 620: From fa_books bk

616:
617: Cursor C_asset_derpn_Info(cp_book_type_code varchar2,
618: cp_asset_id number) Is
619: Select depreciate_flag
620: From fa_books bk
621: Where bk.book_type_code = cp_book_type_code
622: and bk.asset_id =cp_asset_id
623: and bk.transaction_header_id_out is null;
624:

Line 681: l_deprn_flag fa_books.depreciate_flag%type;

677: l_deprn c_deprn%rowtype;
678: l_login_id NUMBER;
679: l_user_id NUMBER;
680: l_path_name VARCHAR2(150);
681: l_deprn_flag fa_books.depreciate_flag%type;
682: l_curr_fiscal_year fa_deprn_periods.fiscal_year%type;
683: l_asset_fiscal_year fa_deprn_periods.fiscal_year%type;
684: l_YTD_prorate_dists_tab igi_iac_types.prorate_dists_tab;
685: l_YTD_prorate_dists_idx binary_integer;