eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_DEPRN_PKG dependencies on FA_DEPRN_SUMMARY

Line 190: FROM fa_deprn_summary

186:
187: /* Cursor to get the assets that are depreciated in the current period by FA */
188: CURSOR c_fa_deprn_records IS
189: SELECT asset_id, deprn_amount
190: FROM fa_deprn_summary
191: WHERE book_type_code = p_book_type_code
192: AND period_counter = p_period_counter ;
193:
194: /* Cursor to get the depreciation amount for the period for the asset */

Line 382: TYPE asset_id_tbl_type IS TABLE OF FA_DEPRN_SUMMARY. ASSET_ID%TYPE

378: l_path VARCHAR2(100);
379: p_event_id NUMBER(15);
380:
381: -- Bulk changes
382: TYPE asset_id_tbl_type IS TABLE OF FA_DEPRN_SUMMARY. ASSET_ID%TYPE
383: INDEX BY BINARY_INTEGER;
384: TYPE deprn_amount_tbl_type IS TABLE OF FA_DEPRN_SUMMARY. DEPRN_AMOUNT%TYPE
385: INDEX BY BINARY_INTEGER;
386: l_fa_asset_id asset_id_tbl_type;

Line 384: TYPE deprn_amount_tbl_type IS TABLE OF FA_DEPRN_SUMMARY. DEPRN_AMOUNT%TYPE

380:
381: -- Bulk changes
382: TYPE asset_id_tbl_type IS TABLE OF FA_DEPRN_SUMMARY. ASSET_ID%TYPE
383: INDEX BY BINARY_INTEGER;
384: TYPE deprn_amount_tbl_type IS TABLE OF FA_DEPRN_SUMMARY. DEPRN_AMOUNT%TYPE
385: INDEX BY BINARY_INTEGER;
386: l_fa_asset_id asset_id_tbl_type;
387: l_fa_deprn_amount deprn_amount_tbl_type;
388: l_loop_count number;

Line 555: -- Fetching the event_id from fa_deprn_summary as in case of depreciation

551: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Inserting into igi_iac_transaction_headers');
552: l_adjustment_id := NULL;
553: l_rowid := NULL;
554:
555: -- Fetching the event_id from fa_deprn_summary as in case of depreciation
556: -- fa is not supplying the event_id
557: -- R12 uptake
558: select event_id into p_event_id from fa_deprn_summary
559: where asset_id=l_fa_asset_id(l_loop_count)

Line 558: select event_id into p_event_id from fa_deprn_summary

554:
555: -- Fetching the event_id from fa_deprn_summary as in case of depreciation
556: -- fa is not supplying the event_id
557: -- R12 uptake
558: select event_id into p_event_id from fa_deprn_summary
559: where asset_id=l_fa_asset_id(l_loop_count)
560: and book_type_code=p_book_type_code
561: and period_counter=p_period_counter;
562: