DBA Data[Home] [Help]

APPS.JL_CO_FA_ACCOUNTING_PKG dependencies on FA_DEPRN_SUMMARY

Line 233: x_adj_cost fa_deprn_summary.adjusted_cost%TYPE;

229: x_reserve_cr NUMBER;
230: x_expense_dr NUMBER;
231: x_expense_cr NUMBER;
232:
233: x_adj_cost fa_deprn_summary.adjusted_cost%TYPE;
234: x_adj_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;

Line 234: x_adj_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;

230: x_expense_dr NUMBER;
231: x_expense_cr NUMBER;
232:
233: x_adj_cost fa_deprn_summary.adjusted_cost%TYPE;
234: x_adj_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;

Line 235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;

231: x_expense_cr NUMBER;
232:
233: x_adj_cost fa_deprn_summary.adjusted_cost%TYPE;
234: x_adj_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;

Line 236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;

232:
233: x_adj_cost fa_deprn_summary.adjusted_cost%TYPE;
234: x_adj_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;

Line 237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;

233: x_adj_cost fa_deprn_summary.adjusted_cost%TYPE;
234: x_adj_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;

Line 238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;

234: x_adj_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;

Line 239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;

235: x_adj_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
243:

Line 240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;

236: x_adj_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
243:
244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;

Line 241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;

237: x_adj_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
243:
244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;
245: x_date_retired fa_retirements.date_retired%TYPE;

Line 242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;

238: x_corp_cost fa_deprn_summary.adjusted_cost%TYPE;
239: x_corp_deprn_reserve fa_deprn_summary.deprn_reserve%TYPE;
240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
243:
244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;
245: x_date_retired fa_retirements.date_retired%TYPE;
246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;

Line 476: FROM fa_deprn_summary

472: IS
473: SELECT nvl (deprn_reserve,0),
474: nvl (reval_reserve,0),
475: nvl (reval_deprn_expense,0)
476: FROM fa_deprn_summary
477: WHERE asset_id = pc_asset_id
478: AND book_type_code = pc_book_type_code
479: AND period_counter = pc_period_counter;
480:

Line 733: fa_deprn_summary ds

729: bk.rowid book_rowid
730: FROM fa_additions ad,
731: fa_asset_history ah,
732: fa_books bk,
733: fa_deprn_summary ds
734: WHERE ds.book_type_code = pc_book_type_code
735: AND ds.period_counter = pc_period_counter
736: AND ad.asset_id = ds.asset_id
737: AND ah.asset_id = ds.asset_id