APPS.IGI_IAC_CATCHUP_PKG dependencies on FA_DEPRN_SUMMARY

Line 104: FROM fa_deprn_summary

100:
101: /* Bug 2961656 vgadde 08-jul-03 Start(1) */
102: CURSOR c_get_user_deprn IS
103: SELECT period_counter,deprn_reserve,YTD_deprn
104: FROM fa_deprn_summary
105: WHERE book_type_code = p_book_type_code
106: AND asset_id = p_asset_id
107: AND deprn_source_code = 'BOOKS';
108: /* Bug 2961656 vgadde 08-jul-03 End(1) */

Line 113: FROM fa_deprn_summary

109:
110: /* Cursor for fetching latest deprn_reserve for RECLASS */
111: CURSOR c_get_deprn_reserve IS
112: SELECT period_counter, deprn_reserve
113: FROM fa_deprn_summary
114: WHERE book_type_code = p_book_type_code
115: AND asset_id = p_asset_id
116: AND period_counter = (SELECT max(period_counter)
117: FROM fa_deprn_summary

Line 117: FROM fa_deprn_summary

113: FROM fa_deprn_summary
114: WHERE book_type_code = p_book_type_code
115: AND asset_id = p_asset_id
116: AND period_counter = (SELECT max(period_counter)
117: FROM fa_deprn_summary
118: WHERE book_type_code = p_book_type_code
119: AND asset_id = p_asset_id);
120:
121: CURSOR c_get_deprn_calendar IS

Line 568: FROM fa_deprn_summary

564: WHERE calendar_type = p_calendar_type;
565:
566: CURSOR c_get_user_deprn IS
567: SELECT period_counter,deprn_reserve,YTD_deprn
568: FROM fa_deprn_summary
569: WHERE book_type_code = p_asset_balance.book_type_code
570: AND asset_id = p_asset_balance.asset_id
571: AND deprn_source_code = 'BOOKS';
572:

Line 1456: FROM fa_deprn_summary

1452:
1453:
1454: CURSOR c_get_user_deprn IS
1455: SELECT period_counter,deprn_reserve,YTD_deprn
1456: FROM fa_deprn_summary
1457: WHERE book_type_code = p_reval_asset_params(1).book_type_code
1458: AND asset_id = p_reval_asset_params(1).asset_id
1459: AND deprn_source_code = 'BOOKS';
1460: