APPS.IGI_IAC_DEPRN_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 279: FROM fa_distribution_history

275:
276: /* Cursor to get number of units assigned for each distribution from FA */
277: CURSOR c_get_distribution_units(p_distribution_id igi_iac_det_balances.distribution_id%TYPE) IS
278: SELECT units_assigned
279: FROM fa_distribution_history
280: WHERE distribution_id = p_distribution_id ;
281:
282: /* Bug 2434532 vgadde 28/06/2002 Start(1) */
283: CURSOR c_get_deprn_calendar IS

Line 336: l_distribution_units fa_distribution_history.units_assigned%TYPE;

332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
334: l_category_id fa_additions.asset_category_id%TYPE;
335: l_asset_units fa_additions.current_units%TYPE;
336: l_distribution_units fa_distribution_history.units_assigned%TYPE;
337: l_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE ;
338: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
339: l_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
340: l_reval_reserve igi_iac_asset_balances.reval_reserve%TYPE;

Line 1159: FROM fa_distribution_history

1155: CURSOR c_get_expense_ccid ( c_asset_id NUMBER,
1156: c_distribution_id NUMBER,
1157: c_transaction_header_id NUMBER) IS
1158: SELECT code_combination_id
1159: FROM fa_distribution_history
1160: WHERE book_type_code = p_book_type_code
1161: AND asset_id = c_asset_id
1162: AND distribution_id = c_distribution_id
1163: AND transaction_header_id_in = nvl(c_transaction_header_id,transaction_header_id_in);

Line 1287: --- get the account from the fa_adjustmemts and fa_distribution_history if not found im

1283: l_account_ccid := l_expense_ccid;
1284: END IF;
1285: END IF;
1286: CLOSE c_get_accounts;
1287: --- get the account from the fa_adjustmemts and fa_distribution_history if not found im
1288: -- fa_distribution_accounts.
1289:
1290: IF (l_account_ccid = -1) THEN
1291: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Could not get account ccid from distribution accounts ');

Line 1343: ,fa_distribution_history d

1339:
1340: SELECT a.category_id
1341: INTO l_category_id
1342: FROM fa_asset_history a
1343: ,fa_distribution_history d
1344: WHERE d.distribution_id = l_dist_id(l_loop_count)
1345: AND a.asset_id = d.asset_id
1346: AND d.date_effective >= a.date_effective
1347: AND d.date_effective < nvl(a.date_ineffective,sysdate);