DBA Data[Home] [Help]

APPS.IGI_IAC_RECLASS_PKG dependencies on FA_DEPRN_SUMMARY

Line 1496: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%TYPE) IS

1492: FROM dual;
1493:
1494: /* To select the asset's deprn_expense from fa_books */
1495:
1496: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%TYPE) IS
1497: SELECT deprn_amount
1498: FROM fa_deprn_summary
1499: WHERE book_type_code = l_asset_hdr_rec.book_type_code
1500: AND period_counter = c_period_counter

Line 1498: FROM fa_deprn_summary

1494: /* To select the asset's deprn_expense from fa_books */
1495:
1496: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%TYPE) IS
1497: SELECT deprn_amount
1498: FROM fa_deprn_summary
1499: WHERE book_type_code = l_asset_hdr_rec.book_type_code
1500: AND period_counter = c_period_counter
1501: AND asset_id=l_asset_hdr_rec.asset_id;
1502:

Line 1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;

1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1599: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1600: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;

Line 2175: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%type) IS

2171: FROM dual;
2172:
2173: /* To select the asset's deprn_expense from fa_books */
2174:
2175: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%type) IS
2176: SELECT deprn_amount
2177: FROM fa_deprn_summary
2178: WHERE book_type_code = l_asset_hdr_rec.book_type_code
2179: AND period_counter = c_period_counter

Line 2177: FROM fa_deprn_summary

2173: /* To select the asset's deprn_expense from fa_books */
2174:
2175: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%type) IS
2176: SELECT deprn_amount
2177: FROM fa_deprn_summary
2178: WHERE book_type_code = l_asset_hdr_rec.book_type_code
2179: AND period_counter = c_period_counter
2180: AND asset_id=l_asset_hdr_rec.asset_id;
2181:

Line 2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;

2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2277: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2278: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;