APPS.IGI_IAC_REINSTATE_PKG dependencies on FA_DEPRN_DETAIL

Line 156: -- fa_deprn_detail for a distribution

152: WHERE iifd.adjustment_id = cp_adjustment_id
153: AND iifd.distribution_id = cp_distribution_id;
154:
155: -- Cursor to fetch depreciation balances from
156: -- fa_deprn_detail for a distribution
157: CURSOR c_get_fa_det(cp_book_type_code VARCHAR2,
158: cp_asset_id NUMBER,
159: cp_distribution_id NUMBER,
160: cp_period_counter NUMBER)

Line 164: FROM fa_deprn_detail

160: cp_period_counter NUMBER)
161: IS
162: SELECT nvl(deprn_reserve,0) deprn_reserve,
163: (nvl(deprn_amount,0) - nvl(deprn_adjustment_amount,0)) deprn_amount
164: FROM fa_deprn_detail
165: WHERE book_type_code = cp_book_type_code
166: AND asset_id = cp_asset_id
167: AND distribution_id = cp_distribution_id
168: AND period_counter = (SELECT max(period_counter)

Line 169: FROM fa_deprn_detail

165: WHERE book_type_code = cp_book_type_code
166: AND asset_id = cp_asset_id
167: AND distribution_id = cp_distribution_id
168: AND period_counter = (SELECT max(period_counter)
169: FROM fa_deprn_detail
170: WHERE book_type_code = cp_book_type_code
171: AND asset_id = cp_asset_id
172: AND distribution_id = cp_distribution_id
173: AND period_counter <= cp_period_counter);

Line 181: FROM fa_deprn_detail fdd

177: cp_asset_id number,
178: cp_distribution_id number)
179: IS
180: SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
181: FROM fa_deprn_detail fdd
182: WHERE fdd.distribution_id = cp_distribution_id
183: AND fdd.book_type_code = cp_book_type_code
184: AND fdd.asset_id = cp_asset_id
185: AND fdd.period_counter IN (SELECT period_counter

Line 275: FROM fa_deprn_detail fdd

271: cp_period_counter number)
272: IS
273: -- SELECT sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
274: SELECT fdd.ytd_deprn
275: FROM fa_deprn_detail fdd
276: WHERE fdd.distribution_id = cp_distribution_id
277: AND fdd.book_type_code = cp_book_type_code
278: AND fdd.asset_id = cp_asset_id
279: AND fdd.period_counter = (SELECT period_counter

Line 663: -- get the deprn values from igi_iac_fa_deprn or fa_deprn_detail

659: l_operating_acct_net := l_operating_acct_cost - l_operating_acct_backlog;
660: l_net_book_value := l_adjustment_cost - (l_deprn_reserve + l_deprn_reserve_backlog);
661:
662: -- bug 2480915 start(5) Modified for bug 2906034
663: -- get the deprn values from igi_iac_fa_deprn or fa_deprn_detail
664: OPEN c_get_fa_deprn(l_prev_adj_id, l_det_bal.distribution_id);
665: FETCH c_get_fa_deprn INTO l_fa_deprn_period, l_fa_deprn_ytd, l_fa_deprn_reserve;
666: IF c_get_fa_deprn%NOTFOUND THEN
667: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Record not found in igi_iac_fa_deprn');