APPS.IGI_IMP_IAC_TRANSFER_PKG dependencies on FA_BOOKS

Line 93: FROM fa_books

89: FOR arec in C_Assets LOOP
90:
91: SELECT depreciate_flag
92: INTO l_depreciate
93: FROM fa_books
94: WHERE book_type_code = arec.book_type_code
95: AND asset_id = arec.asset_id
96: AND date_ineffective is NULL; -- Bug 5383551
97:

Line 161: FROM fa_books fab, fa_deprn_periods fdp

157: fab.life_in_months - floor(months_between(
158: fdp.CALENDAR_PERIOD_CLOSE_DATE,
159: fab.deprn_start_date)))
160: INTO l_remaining_periods
161: FROM fa_books fab, fa_deprn_periods fdp
162: WHERE fab.book_type_code = arec.book_type_code
163: AND fdp.book_type_code = arec.book_type_code
164: AND fab.asset_id = arec.asset_id
165: AND fab.date_ineffective is null

Line 942: FROM FA_BOOKS

938: -- Bug 3575041 start(2) --
939:
940: CURSOR C_Get_Deprn_Flag is
941: SELECT depreciate_flag
942: FROM FA_BOOKS
943: WHERE book_type_code = p_book_type_code
944: AND asset_id = p_asset_id
945: AND transaction_header_id_out is NULL;
946:

Line 947: l_depreciate_flag FA_BOOKS.depreciate_flag%TYPE;

943: WHERE book_type_code = p_book_type_code
944: AND asset_id = p_asset_id
945: AND transaction_header_id_out is NULL;
946:
947: l_depreciate_flag FA_BOOKS.depreciate_flag%TYPE;
948:
949: -- Bug 3575041 end(2) --
950:
951: BEGIN

Line 1886: From fa_books bk

1882: bk.depreciate_flag,
1883: bk.fully_rsvd_revals_counter,
1884: bk.period_counter_fully_reserved,
1885: bk.period_counter_fully_retired
1886: From fa_books bk
1887: Where bk.book_type_code = cp_book
1888: and bk.asset_id = cp_asset_id
1889: and bk.transaction_header_id_out is null;
1890: