APPS.FA_SORP_UPG_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 287: FA_MC_DEPRN_SUMMARY su

283: FA_MC_ITF_IMPAIRMENTS itf,
284: FA_MC_IMPAIRMENTS imp,
285: fa_transaction_headers th,
286: fa_adjustments adj,
287: FA_MC_DEPRN_SUMMARY su
288: where itf.impairment_id = imp.impairment_id
289: and itf.impairment_id = th.mass_transaction_id
290: and th.transaction_header_id = adj.transaction_header_id
291: and su.period_counter = itf.period_counter

Line 980: FROM FA_MC_DEPRN_SUMMARY dep, fa_additions_v adda

976: SELECT DISTINCT adda.asset_id, adda.asset_number,
977: adda.description asset_description,
978: adda.asset_category_id,
979: adda.attribute_category_code category_name
980: FROM FA_MC_DEPRN_SUMMARY dep, fa_additions_v adda
981: WHERE adda.asset_id = dep.asset_id
982: AND book_type_code = p_book_type_code;
983:
984: v_asset_cur c_asset_cur%ROWTYPE;

Line 1008: FROM FA_MC_DEPRN_SUMMARY

1004: CURSOR c_deprn_summary_cur
1005: IS
1006: SELECT deprn_reserve, deprn_amount, reval_amortization,
1007: impairment_amount, period_counter,set_of_books_id
1008: FROM FA_MC_DEPRN_SUMMARY
1009: WHERE book_type_code = p_book_type_code AND asset_id = v_asset_id
1010: ORDER BY SET_OF_BOOKS_ID ASC,period_counter;
1011:
1012: v_deprn_summary_cur c_deprn_summary_cur%ROWTYPE;

Line 1261: UPDATE FA_MC_DEPRN_SUMMARY

1257: + NVL(l_ret_gen_det_value,0);
1258:
1259: l_old_sob_id := v_deprn_summary_cur.set_of_books_id;
1260:
1261: UPDATE FA_MC_DEPRN_SUMMARY
1262: SET capital_adjustment = v_capital_adj_summary_amount,
1263: general_fund = v_general_fund_summary_amount
1264: WHERE asset_id = v_asset_id
1265: AND book_type_code = p_book_type_code

Line 1282: UPDATE FA_MC_DEPRN_SUMMARY

1278: + NVL (v_deprn_summary_cur.deprn_amount, 0)
1279: + NVL (v_deprn_summary_cur.impairment_amount, 0)
1280: + NVL(l_ret_gen_det_value,0);
1281:
1282: UPDATE FA_MC_DEPRN_SUMMARY
1283: SET capital_adjustment = v_capital_adj_summary_amount,
1284: general_fund = v_general_fund_summary_amount
1285: WHERE asset_id = v_asset_id
1286: AND book_type_code = p_book_type_code

Line 1859: from FA_MC_DEPRN_SUMMARY

1855: l_period_counter number)
1856: is
1857: select capital_adjustment,
1858: general_fund
1859: from FA_MC_DEPRN_SUMMARY
1860: where book_type_code = l_book
1861: and asset_id = l_asset_id
1862: and period_counter = (select max(period_counter)
1863: from FA_MC_DEPRN_SUMMARY

Line 1863: from FA_MC_DEPRN_SUMMARY

1859: from FA_MC_DEPRN_SUMMARY
1860: where book_type_code = l_book
1861: and asset_id = l_asset_id
1862: and period_counter = (select max(period_counter)
1863: from FA_MC_DEPRN_SUMMARY
1864: where book_type_code = l_book
1865: and asset_id = l_asset_id
1866: and period_counter < l_period_counter);
1867: