DBA Data[Home] [Help]

APPS.IGI_IAC_RECLASS_PKG dependencies on FA_DEPRN_SUMMARY

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

1459: FROM dual;
1460:
1461: /* To select the asset's deprn_expense from fa_books */
1462:
1463: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%TYPE) IS
1464: SELECT deprn_amount
1465: FROM fa_deprn_summary
1466: WHERE book_type_code = l_asset_hdr_rec.book_type_code
1467: AND period_counter = c_period_counter

Line 1465: FROM fa_deprn_summary

1461: /* To select the asset's deprn_expense from fa_books */
1462:
1463: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%TYPE) IS
1464: SELECT deprn_amount
1465: FROM fa_deprn_summary
1466: WHERE book_type_code = l_asset_hdr_rec.book_type_code
1467: AND period_counter = c_period_counter
1468: AND asset_id=l_asset_hdr_rec.asset_id;
1469:

Line 1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;

1559: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1560: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1561: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1562: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1563: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1564: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1565: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1566: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
1567: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%TYPE;

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

2138: FROM dual;
2139:
2140: /* To select the asset's deprn_expense from fa_books */
2141:
2142: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%type) IS
2143: SELECT deprn_amount
2144: FROM fa_deprn_summary
2145: WHERE book_type_code = l_asset_hdr_rec.book_type_code
2146: AND period_counter = c_period_counter

Line 2144: FROM fa_deprn_summary

2140: /* To select the asset's deprn_expense from fa_books */
2141:
2142: CURSOR c_deprn_expense(c_period_counter FA_DEPRN_SUMMARY.period_counter%type) IS
2143: SELECT deprn_amount
2144: FROM fa_deprn_summary
2145: WHERE book_type_code = l_asset_hdr_rec.book_type_code
2146: AND period_counter = c_period_counter
2147: AND asset_id=l_asset_hdr_rec.asset_id;
2148:

Line 2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;

2237: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2238: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2239: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2240: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2241: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2242: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2243: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2244: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;
2245: l_adjustment_id IGI_IAC_ADJUSTMENTS.adjustment_id%type;