APPS.IGI_IAC_CATCHUP_PKG dependencies on FA_DEPRN_SUMMARY

Line 121: FROM fa_deprn_summary

117:
118: /* Bug 2961656 vgadde 08-jul-03 Start(1) */
119: CURSOR c_get_user_deprn IS
120: SELECT period_counter,deprn_reserve,YTD_deprn
121: FROM fa_deprn_summary
122: WHERE book_type_code = p_book_type_code
123: AND asset_id = p_asset_id
124: AND deprn_source_code = 'BOOKS';
125: /* Bug 2961656 vgadde 08-jul-03 End(1) */

Line 130: FROM fa_deprn_summary

126:
127: /* Cursor for fetching latest deprn_reserve for RECLASS */
128: CURSOR c_get_deprn_reserve IS
129: SELECT period_counter, deprn_reserve
130: FROM fa_deprn_summary
131: WHERE book_type_code = p_book_type_code
132: AND asset_id = p_asset_id
133: AND period_counter = (SELECT max(period_counter)
134: FROM fa_deprn_summary

Line 134: FROM fa_deprn_summary

130: FROM fa_deprn_summary
131: WHERE book_type_code = p_book_type_code
132: AND asset_id = p_asset_id
133: AND period_counter = (SELECT max(period_counter)
134: FROM fa_deprn_summary
135: WHERE book_type_code = p_book_type_code
136: AND asset_id = p_asset_id);
137:
138: CURSOR c_get_deprn_calendar IS

Line 610: FROM fa_deprn_summary

606: WHERE calendar_type = p_calendar_type;
607:
608: CURSOR c_get_user_deprn IS
609: SELECT period_counter,deprn_reserve,YTD_deprn
610: FROM fa_deprn_summary
611: WHERE book_type_code = p_asset_balance.book_type_code
612: AND asset_id = p_asset_balance.asset_id
613: AND deprn_source_code = 'BOOKS';
614:

Line 1539: FROM fa_deprn_summary

1535:
1536:
1537: CURSOR c_get_user_deprn IS
1538: SELECT period_counter,deprn_reserve,YTD_deprn
1539: FROM fa_deprn_summary
1540: WHERE book_type_code = p_reval_asset_params(1).book_type_code
1541: AND asset_id = p_reval_asset_params(1).asset_id
1542: AND deprn_source_code = 'BOOKS';
1543: