APPS.IGI_IMP_IAC_PREPARE_PKG dependencies on FA_DEPRN_SUMMARY

Line 88: From fa_deprn_summary

84: nvl(deprn_reserve,0) deprn_reserve,
85: deprn_source_code,
86: nvl(reval_reserve,0) reval_reserve,
87: nvl(adjusted_cost,0) adjusted_cost
88: From fa_deprn_summary
89: Where book_type_code = p_book
90: and period_counter = p_period_counter
91: and asset_id = p_asset_id
92: and deprn_source_code = 'DEPRN';

Line 97: From fa_deprn_summary

93:
94: Cursor C_Corp_Max_Period_Counter(p_book in varchar2,
95: p_asset_id in number) Is
96: Select max(Period_counter) period_counter
97: From fa_deprn_summary
98: Where book_type_code = p_book
99: and asset_id = p_asset_id
100: and deprn_source_code = 'DEPRN';
101:

Line 997: FROM fa_deprn_summary

993:
994: /* Bug 2961656 vgadde 08-jul-03 start(1) */
995: CURSOR C_Get_User_Deprn(p_asset_id in number ) IS
996: SELECT period_counter, deprn_reserve, ytd_deprn
997: FROM fa_deprn_summary
998: WHERE book_type_code = p_corp_book
999: AND asset_id = p_asset_id
1000: AND deprn_source_code = 'BOOKS';
1001: /* Bug 2961656 vgadde 08-jul-03 end(1) */

Line 1157: From fa_deprn_summary

1153: IF l_Corp_last_per_counter IS NULL THEN
1154:
1155: Select max(Period_counter)
1156: Into l_Corp_last_per_counter
1157: From fa_deprn_summary
1158: Where book_type_code = p_corp_book
1159: and asset_id = C_Book_Info_Rec.asset_id;
1160:
1161: END IF;