APPS.FA_SORP_UPG_PKG dependencies on FA_MC_DEPRN_DETAIL

Line 257: FA_MC_DEPRN_DETAIL det

253: FA_MC_ITF_IMPAIRMENTS itf,
254: FA_MC_IMPAIRMENTS imp,
255: fa_transaction_headers th,
256: fa_adjustments adj,
257: FA_MC_DEPRN_DETAIL det
258: where itf.impairment_id = imp.impairment_id
259: and itf.impairment_id = th.mass_transaction_id
260: and th.transaction_header_id = adj.transaction_header_id
261: and adj.distribution_id = det.distribution_id

Line 541: FA_MC_DEPRN_DETAIL sumold

537: INTO
538: l_old_dist_ca,
539: l_old_dist_gf
540: FROM FA_DISTRIBUTION_HISTORY dh_old,
541: FA_MC_DEPRN_DETAIL sumold
542: WHERE dh_old.distribution_id = sumold.distribution_id
543: AND dh_old.book_type_code = sumold.book_type_code
544: AND dh_old.asset_id = sumold.asset_id
545: ANd dh_old.retirement_id is not null

Line 560: FROM FA_MC_DEPRN_DETAIL

556: AND dh_new.book_type_code = dh_old.book_type_code
557: )
558: AND sumold.period_counter =
559: (SELECT MAX(period_counter)
560: FROM FA_MC_DEPRN_DETAIL
561: WHERE book_type_code = p_book_type_code
562: AND asset_id = p_asset_id
563: AND distribution_id = p_dist_id
564: AND period_counter < p_period_counter

Line 998: FROM FA_MC_DEPRN_DETAIL

994: CURSOR c_deprn_cur
995: IS
996: SELECT distribution_id, deprn_reserve, deprn_amount,
997: reval_amortization, impairment_amount, period_counter,set_of_books_id
998: FROM FA_MC_DEPRN_DETAIL
999: WHERE book_type_code = p_book_type_code AND asset_id = v_asset_id
1000: ORDER BY SET_OF_BOOKS_ID ASC,period_counter;
1001:
1002: v_deprn_cur c_deprn_cur%ROWTYPE;

Line 1168: UPDATE FA_MC_DEPRN_DETAIL

1164: l_old_sob_id := v_deprn_cur.set_of_books_id;
1165:
1166: IF p_mode = 'FINAL'
1167: THEN
1168: UPDATE FA_MC_DEPRN_DETAIL
1169: SET capital_adjustment = v_capital_adj_amount,
1170: general_fund = v_general_fund_amount
1171: WHERE distribution_id = v_deprn_cur.distribution_id
1172: AND book_type_code = p_book_type_code

Line 1192: UPDATE FA_MC_DEPRN_DETAIL

1188: + NVL(l_ret_gen_det_value,0);
1189:
1190: IF p_mode = 'FINAL'
1191: THEN
1192: UPDATE FA_MC_DEPRN_DETAIL
1193: SET capital_adjustment = v_capital_adj_amount,
1194: general_fund = v_general_fund_amount
1195: WHERE distribution_id = v_deprn_cur.distribution_id
1196: AND book_type_code = p_book_type_code