APPS.FA_SORP_REVALUATION_PKG dependencies on FA_ITF_IMPAIRMENTS

Line 52: from fa_ITF_impairments

48: '1', split1_loss_amount,
49: '2', split2_loss_amount,
50: '3', split3_loss_amount
51: )) split_impairm_amount
52: from fa_ITF_impairments
53: where asset_id = p_asset_id and
54: impairment_id=fa_sorp_process_imp_id_fn(p_impairment_id) and
55: book_type_code=p_book_type_code;
56:

Line 520: fa_itf_impairments itf

516: ) deprn_delta
517: FROM fa_deprn_summary deprn_sum,
518: fa_deprn_periods deprn_periods,
519: fa_impairments imp,
520: fa_itf_impairments itf
521: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
522: AND deprn_sum.period_counter = deprn_periods.period_counter
523: AND deprn_sum.period_counter = imp.period_counter_impaired
524: AND deprn_sum.book_type_code = imp.book_type_code

Line 609: fa_itf_impairments itf

605: ) deprn_delta
606: FROM fa_deprn_summary deprn_sum,
607: fa_deprn_periods deprn_periods,
608: fa_impairments imp,
609: fa_itf_impairments itf
610: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
611: AND deprn_sum.period_counter = deprn_periods.period_counter
612: AND deprn_sum.period_counter = imp.period_counter_impaired
613: AND deprn_sum.book_type_code = imp.book_type_code

Line 633: fa_itf_impairments itf

629: ) deprn_delta
630: FROM fa_deprn_summary deprn_sum,
631: fa_deprn_periods deprn_periods,
632: fa_impairments imp,
633: fa_itf_impairments itf
634: WHERE deprn_sum.book_type_code = deprn_periods.book_type_code
635: AND deprn_sum.period_counter = deprn_periods.period_counter
636: AND deprn_sum.period_counter = imp.period_counter_impaired
637: AND deprn_sum.book_type_code = imp.book_type_code

Line 712: FROM fa_itf_impairments itf

708: )
709: ) reserve_adj_amount
710: INTO v_impair_loss_amount,
711: v_reserve_adj_amount
712: FROM fa_itf_impairments itf
713: WHERE impairment_id = fa_sorp_process_imp_id_fn (p_impairment_id);
714:
715: OPEN c_deprn_imp_amt_cur;
716:

Line 1870: /* Procedure updates FA_ITF_IMPAIRMENTS with reversed amounts

1866:
1867: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'End', 'End', p_log_level_rec => p_log_level_rec);
1868: END fa_sorp_link_reval;
1869:
1870: /* Procedure updates FA_ITF_IMPAIRMENTS with reversed amounts
1871:
1872: */
1873: PROCEDURE fa_imp_itf_upd (
1874: p_request_id NUMBER,

Line 1913: UPDATE fa_itf_impairments

1909: IF NVL (v_split_number, 0) = 0
1910: THEN
1911: IF NVL (v_calc_imp_reverse_amt, 0) <> 0
1912: THEN
1913: UPDATE fa_itf_impairments
1914: SET reversed_imp_amt = nvl(reversed_imp_amt,0)+v_calc_imp_reverse_amt,
1915: reversed_deprn_impact = nvl(reversed_deprn_impact,0)+v_calc_imp_rev_deprn_effect,
1916: last_updated_by = p_last_updated_by,
1917: last_update_date = p_last_update_date

Line 1923: UPDATE fa_itf_impairments

1919: END IF;
1920:
1921: IF NVL (v_rsv_reverse_amt, 0) <> 0
1922: THEN
1923: UPDATE fa_itf_impairments
1924: SET reversed_reval_amt = nvl(reversed_reval_amt,0)+v_rsv_reverse_amt,
1925: reversed_reval_impact = nvl(reversed_reval_impact,0)+v_rsv_reverse_deprn_effect,
1926: last_updated_by = p_last_updated_by,
1927: last_update_date = p_last_update_date

Line 1934: UPDATE fa_itf_impairments

1930: ELSIF NVL (v_split_number, 0) = 1
1931: THEN
1932: IF NVL (v_calc_imp_reverse_amt, 0) <> 0
1933: THEN
1934: UPDATE fa_itf_impairments
1935: SET reversed_imp_amt_s1 = nvl(reversed_imp_amt_s1,0)+v_calc_imp_reverse_amt,
1936: reversed_deprn_impact_s1 = nvl(reversed_deprn_impact_s1,0)+v_calc_imp_rev_deprn_effect,
1937: last_updated_by = p_last_updated_by,
1938: last_update_date = p_last_update_date

Line 1944: UPDATE fa_itf_impairments

1940: END IF;
1941:
1942: IF NVL (v_rsv_reverse_amt, 0) <> 0
1943: THEN
1944: UPDATE fa_itf_impairments
1945: SET reversed_reval_amt_s1 = nvl(reversed_reval_amt_s1,0)+v_rsv_reverse_amt,
1946: reversed_reval_impact_s1 = nvl(reversed_reval_impact_s1,0)+v_rsv_reverse_deprn_effect,
1947: last_updated_by = p_last_updated_by,
1948: last_update_date = p_last_update_date

Line 1955: UPDATE fa_itf_impairments

1951: ELSIF NVL (v_split_number, 0) = 2
1952: THEN
1953: IF NVL (v_calc_imp_reverse_amt, 0) <> 0
1954: THEN
1955: UPDATE fa_itf_impairments
1956: SET reversed_imp_amt_s2 = nvl(reversed_imp_amt_s2,0)+v_calc_imp_reverse_amt,
1957: reversed_deprn_impact_s2 = nvl(reversed_deprn_impact_s2,0)+v_calc_imp_rev_deprn_effect,
1958: last_updated_by = p_last_updated_by,
1959: last_update_date = p_last_update_date

Line 1965: UPDATE fa_itf_impairments

1961: END IF;
1962:
1963: IF NVL (v_rsv_reverse_amt, 0) <> 0
1964: THEN
1965: UPDATE fa_itf_impairments
1966: SET reversed_reval_amt_s2 = nvl(reversed_reval_amt_s2,0)+v_rsv_reverse_amt,
1967: reversed_reval_impact_s2 = nvl(reversed_reval_impact_s2,0)+v_rsv_reverse_deprn_effect,
1968: last_updated_by = p_last_updated_by,
1969: last_update_date = p_last_update_date

Line 1976: UPDATE fa_itf_impairments

1972: ELSIF NVL (v_split_number, 0) = 3
1973: THEN
1974: IF NVL (v_calc_imp_reverse_amt, 0) <> 0
1975: THEN
1976: UPDATE fa_itf_impairments
1977: SET reversed_imp_amt_s3 = nvl(reversed_imp_amt_s3,0)+v_calc_imp_reverse_amt,
1978: reversed_deprn_impact_s3 = nvl(reversed_deprn_impact_s3,0)+v_calc_imp_rev_deprn_effect,
1979: last_updated_by = p_last_updated_by,
1980: last_update_date = p_last_update_date

Line 1986: UPDATE fa_itf_impairments

1982: END IF;
1983:
1984: IF NVL (v_rsv_reverse_amt, 0) <> 0
1985: THEN
1986: UPDATE fa_itf_impairments
1987: SET reversed_reval_amt_s3 = nvl(reversed_reval_amt_s3,0)+v_rsv_reverse_amt,
1988: reversed_reval_impact_s3 = nvl(reversed_reval_impact_s3,0)+v_rsv_reverse_deprn_effect,
1989: last_updated_by = p_last_updated_by,
1990: last_update_date = p_last_update_date