APPS.FA_SORP_UPG_PKG dependencies on FA_DEPRN_SUMMARY

Line 172: fa_deprn_summary su

168: fa_itf_impairments itf,
169: fa_impairments imp,
170: fa_transaction_headers th,
171: fa_adjustments adj,
172: fa_deprn_summary su
173: where itf.impairment_id = imp.impairment_id
174: and itf.impairment_id = th.mass_transaction_id
175: and th.transaction_header_id = adj.transaction_header_id
176: and su.period_counter = itf.period_counter

Line 842: FROM fa_deprn_summary dep, fa_additions_v adda

838: IS
839: SELECT DISTINCT dep.asset_id, adda.asset_number,
840: adda.asset_category_id,
841: adda.attribute_category_code category_name
842: FROM fa_deprn_summary dep, fa_additions_v adda
843: WHERE adda.asset_id = dep.asset_id
844: AND book_type_code = p_book_type_code;
845:
846: CURSOR c_deprn_apr_cur

Line 850: FROM fa_deprn_summary dep

846: CURSOR c_deprn_apr_cur
847: IS
848: SELECT reval_reserve
849: FROM (SELECT dep.reval_reserve
850: FROM fa_deprn_summary dep
851: WHERE dep.book_type_code = p_book_type_code
852: AND dep.asset_id = v_asset_id
853: AND dep.period_counter < v_period_counter
854: ORDER BY dep.period_counter DESC)

Line 860: FROM fa_deprn_summary dep

856:
857: CURSOR c_deprn_cur
858: IS
859: SELECT dep.reval_reserve
860: FROM fa_deprn_summary dep
861: WHERE dep.book_type_code = p_book_type_code
862: AND dep.asset_id = v_asset_id
863: AND dep.period_counter =
864: (SELECT MAX (period_counter)

Line 865: FROM fa_deprn_summary

861: WHERE dep.book_type_code = p_book_type_code
862: AND dep.asset_id = v_asset_id
863: AND dep.period_counter =
864: (SELECT MAX (period_counter)
865: FROM fa_deprn_summary
866: WHERE book_type_code = p_book_type_code
867: AND asset_id = v_asset_id
868: GROUP BY asset_id);
869: BEGIN

Line 1404: FROM fa_deprn_summary dep, fa_additions_v adda

1400: SELECT DISTINCT adda.asset_id, adda.asset_number,
1401: adda.description asset_description,
1402: adda.asset_category_id,
1403: adda.attribute_category_code category_name
1404: FROM fa_deprn_summary dep, fa_additions_v adda
1405: WHERE adda.asset_id = dep.asset_id
1406: AND book_type_code = p_book_type_code;
1407:
1408: v_asset_cur c_asset_cur%ROWTYPE;

Line 1432: FROM fa_deprn_summary

1428: CURSOR c_deprn_summary_cur
1429: IS
1430: SELECT deprn_reserve, deprn_amount, reval_amortization,
1431: impairment_amount, period_counter
1432: FROM fa_deprn_summary
1433: WHERE book_type_code = p_book_type_code AND asset_id = v_asset_id
1434: ORDER BY period_counter;
1435:
1436: v_deprn_summary_cur c_deprn_summary_cur%ROWTYPE;

Line 1681: UPDATE fa_deprn_summary

1677: NVL (v_deprn_summary_cur.deprn_reserve, 0)
1678: + NVL (v_deprn_summary_cur.impairment_amount, 0)
1679: + NVL(l_ret_gen_det_value,0);
1680:
1681: UPDATE fa_deprn_summary
1682: SET capital_adjustment = v_capital_adj_summary_amount,
1683: general_fund = v_general_fund_summary_amount
1684: WHERE asset_id = v_asset_id
1685: AND book_type_code = p_book_type_code

Line 1702: UPDATE fa_deprn_summary

1698: + NVL (v_deprn_summary_cur.impairment_amount, 0)
1699: + NVL(l_ret_gen_det_value,0);
1700:
1701:
1702: UPDATE fa_deprn_summary
1703: SET capital_adjustment = v_capital_adj_summary_amount,
1704: general_fund = v_general_fund_summary_amount
1705: WHERE asset_id = v_asset_id
1706: AND book_type_code = p_book_type_code

Line 2405: from fa_deprn_summary

2401: l_period_counter number)
2402: is
2403: select capital_adjustment,
2404: general_fund
2405: from fa_deprn_summary
2406: where book_type_code = l_book
2407: and asset_id = l_asset_id
2408: and period_counter = (select max(period_counter)
2409: from fa_deprn_summary

Line 2409: from fa_deprn_summary

2405: from fa_deprn_summary
2406: where book_type_code = l_book
2407: and asset_id = l_asset_id
2408: and period_counter = (select max(period_counter)
2409: from fa_deprn_summary
2410: where book_type_code = l_book
2411: and asset_id = l_asset_id
2412: and period_counter < l_period_counter);
2413: