APPS.FA_SORP_REVALUATION_PKG dependencies on FA_SORP_LINK_REVAL_ITF

Line 826: FROM fa_sorp_link_reval_itf

822: SELECT impairment_id, reval_reserve_impact_flag, impair_loss_impact,
823: imp_deprn_effect, NVL (impair_loss_acct, 'N'),
824: calc_imp_reverse_amt, calc_imp_reverse_deprn_effect,
825: rsv_reverse_amt, rsv_reverse_deprn_effect
826: FROM fa_sorp_link_reval_itf
827: WHERE request_id = p_request_id
828: AND asset_id = p_asset_id
829: AND run_mode = 'RUN';
830:

Line 1338: INSERT INTO fa_sorp_link_reval_itf

1334: x_reval_gain := l_reval_gain;
1335: x_temp_imp_deprn_effect := v_temp_imp_deprn_effect;
1336: x_impair_loss_acct := v_impair_loss_acct;
1337:
1338: INSERT INTO fa_sorp_link_reval_itf
1339: (request_id, mass_reval_id, asset_id,
1340: category_id, book_type_code,
1341: impairment_id,
1342: split_number, impairment_loss_amount,

Line 1495: INSERT INTO fa_sorp_link_reval_itf

1491: x_reval_gain := l_reval_gain;
1492: x_temp_imp_deprn_effect := v_temp_imp_deprn_effect;
1493: x_impair_loss_acct := v_impair_loss_acct;
1494:
1495: INSERT INTO fa_sorp_link_reval_itf
1496: (request_id, mass_reval_id, asset_id,
1497: category_id, book_type_code,
1498: impairment_id,
1499: split_number, impairment_loss_amount,

Line 1654: INSERT INTO fa_sorp_link_reval_itf

1650: x_reval_gain := l_reval_gain;
1651: x_temp_imp_deprn_effect := v_temp_imp_deprn_effect;
1652: x_impair_loss_acct := v_impair_loss_acct;
1653:
1654: INSERT INTO fa_sorp_link_reval_itf
1655: (request_id, mass_reval_id, asset_id,
1656: category_id, book_type_code,
1657: impairment_id,
1658: split_number, impairment_loss_amount,

Line 1810: INSERT INTO fa_sorp_link_reval_itf

1806: x_reval_gain := l_reval_gain;
1807: x_temp_imp_deprn_effect := v_temp_imp_deprn_effect;
1808: x_impair_loss_acct := v_impair_loss_acct;
1809:
1810: INSERT INTO fa_sorp_link_reval_itf
1811: (request_id, mass_reval_id, asset_id,
1812: category_id, book_type_code,
1813: impairment_id,
1814: split_number, impairment_loss_amount,

Line 1886: FROM fa_sorp_link_reval_itf

1882: IS
1883: SELECT impairment_id, split_number, calc_imp_reverse_amt,
1884: calc_imp_reverse_deprn_effect, rsv_reverse_amt,
1885: rsv_reverse_deprn_effect
1886: FROM fa_sorp_link_reval_itf
1887: WHERE request_id = p_request_id
1888: AND book_type_code = p_book_type_code
1889: AND asset_id = p_asset_id
1890: AND run_mode = 'RUN';