APPS.FA_SORP_UPG_PKG dependencies on FA_DEPRN_DETAIL

Line 143: fa_deprn_detail det

139: fa_itf_impairments itf,
140: fa_impairments imp,
141: fa_transaction_headers th,
142: fa_adjustments adj,
143: fa_deprn_detail det
144: where itf.impairment_id = imp.impairment_id
145: and itf.impairment_id = th.mass_transaction_id
146: and th.transaction_header_id = adj.transaction_header_id
147: and adj.distribution_id = det.distribution_id

Line 423: FA_DEPRN_DETAIL sumold

419: INTO
420: l_old_dist_ca,
421: l_old_dist_gf
422: FROM FA_DISTRIBUTION_HISTORY dh_old,
423: FA_DEPRN_DETAIL sumold
424: WHERE dh_old.distribution_id = sumold.distribution_id
425: AND dh_old.book_type_code = sumold.book_type_code
426: AND dh_old.asset_id = sumold.asset_id
427: ANd dh_old.retirement_id is not null

Line 441: FROM FA_DEPRN_DETAIL

437: AND dh_new.book_type_code = dh_old.book_type_code
438: )
439: AND sumold.period_counter =
440: (SELECT MAX(period_counter)
441: FROM FA_DEPRN_DETAIL
442: WHERE book_type_code = p_book_type_code
443: AND asset_id = p_asset_id
444: AND distribution_id = p_dist_id
445: AND period_counter < p_period_counter);

Line 1422: FROM fa_deprn_detail

1418: CURSOR c_deprn_cur
1419: IS
1420: SELECT distribution_id, deprn_reserve, deprn_amount,
1421: reval_amortization, impairment_amount, period_counter
1422: FROM fa_deprn_detail
1423: WHERE book_type_code = p_book_type_code AND asset_id = v_asset_id
1424: ORDER BY period_counter;
1425:
1426: v_deprn_cur c_deprn_cur%ROWTYPE;

Line 1600: UPDATE fa_deprn_detail

1596:
1597:
1598: IF p_mode = 'FINAL'
1599: THEN
1600: UPDATE fa_deprn_detail
1601: SET capital_adjustment = v_capital_adj_amount,
1602: general_fund = v_general_fund_amount
1603: WHERE distribution_id = v_deprn_cur.distribution_id
1604: AND book_type_code = p_book_type_code

Line 1623: UPDATE fa_deprn_detail

1619: + NVL(l_ret_gen_det_value,0);
1620:
1621: IF p_mode = 'FINAL'
1622: THEN
1623: UPDATE fa_deprn_detail
1624: SET capital_adjustment = v_capital_adj_amount,
1625: general_fund = v_general_fund_amount
1626: WHERE distribution_id = v_deprn_cur.distribution_id
1627: AND book_type_code = p_book_type_code