300: AND distribution_id = cp_distribution_id
301: AND period_counter = p_period_counter - 1
302: AND nvl(active_flag,'Y') = 'N';
303:
304: CURSOR c_get_iac_fa_deprn_dists(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
305: ,cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
306: SELECT *
307: FROM igi_iac_fa_deprn
308: WHERE book_type_code = p_book_type_code
301: AND period_counter = p_period_counter - 1
302: AND nvl(active_flag,'Y') = 'N';
303:
304: CURSOR c_get_iac_fa_deprn_dists(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
305: ,cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
306: SELECT *
307: FROM igi_iac_fa_deprn
308: WHERE book_type_code = p_book_type_code
309: AND asset_id = cp_asset_id
303:
304: CURSOR c_get_iac_fa_deprn_dists(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
305: ,cp_adjustment_id igi_iac_fa_deprn.adjustment_id%TYPE) IS
306: SELECT *
307: FROM igi_iac_fa_deprn
308: WHERE book_type_code = p_book_type_code
309: AND asset_id = cp_asset_id
310: AND adjustment_id = cp_adjustment_id;
311:
308: WHERE book_type_code = p_book_type_code
309: AND asset_id = cp_asset_id
310: AND adjustment_id = cp_adjustment_id;
311:
312: CURSOR c_get_prev_year_fa_inactive(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
313: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
314: SELECT 'X'
315: FROM igi_iac_fa_deprn
316: WHERE book_type_code = p_book_type_code
309: AND asset_id = cp_asset_id
310: AND adjustment_id = cp_adjustment_id;
311:
312: CURSOR c_get_prev_year_fa_inactive(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
313: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
314: SELECT 'X'
315: FROM igi_iac_fa_deprn
316: WHERE book_type_code = p_book_type_code
317: AND asset_id = cp_asset_id
311:
312: CURSOR c_get_prev_year_fa_inactive(cp_asset_id igi_iac_fa_deprn.asset_id%TYPE
313: ,cp_distribution_id igi_iac_fa_deprn.distribution_id%TYPE) IS
314: SELECT 'X'
315: FROM igi_iac_fa_deprn
316: WHERE book_type_code = p_book_type_code
317: AND asset_id = cp_asset_id
318: AND distribution_id = cp_distribution_id
319: AND period_counter = p_period_counter - 1
936: IF (nvl(l_iac_fa_deprn_dist.active_flag,'Y') <> 'N') THEN
937:
938: FOR l_fa_dist_amounts IN c_get_dist_deprn_amount(l_asset_balance.asset_id,l_iac_fa_deprn_dist.distribution_id) LOOP
939: l_rowid := NULL;
940: igi_iac_fa_deprn_pkg.insert_row(
941: x_rowid => l_rowid,
942: x_book_type_code => p_book_type_code,
943: x_asset_id => l_asset_balance.asset_id,
944: x_distribution_id => l_iac_fa_deprn_dist.distribution_id,
955: END IF;
956:
957: IF ((nvl(l_iac_fa_deprn_dist.active_flag,'Y') = 'N') AND (NOT l_is_first_period)) THEN
958: l_rowid := NULL;
959: igi_iac_fa_deprn_pkg.insert_row(
960: x_rowid => l_rowid,
961: x_book_type_code => l_iac_fa_deprn_dist.book_type_code,
962: x_asset_id => l_iac_fa_deprn_dist.asset_id,
963: x_distribution_id => l_iac_fa_deprn_dist.distribution_id,
979: CLOSE c_get_prev_year_fa_inactive;
980:
981: IF l_prev_year_inactive_dist IS NULL THEN
982: l_rowid := NULL;
983: igi_iac_fa_deprn_pkg.insert_row(
984: x_rowid => l_rowid,
985: x_book_type_code => l_iac_fa_deprn_dist.book_type_code,
986: x_asset_id => l_iac_fa_deprn_dist.asset_id,
987: x_distribution_id => l_iac_fa_deprn_dist.distribution_id,