APPS.FA_TXRSV_PKG dependencies on FA_BOOKS_MRC_V

Line 110: UPDATE FA_BOOKS_MRC_V

106: * do with the problem except ANNUAL_DEPRN_ROUNDING_FLAG.
107: */
108: if (X_mrc_sob_type_code = 'R') then
109:
110: UPDATE FA_BOOKS_MRC_V
111: SET DATE_INEFFECTIVE = X_sysdate,
112: TRANSACTION_HEADER_ID_OUT = X_th_id,
113: LAST_UPDATE_DATE = X_sysdate,
114: LAST_UPDATED_BY = NVL (X_user_id, -1),

Line 120: INSERT INTO FA_BOOKS_MRC_V (

116: WHERE ASSET_ID = X_asset_id
117: AND BOOK_TYPE_CODE = X_book
118: AND DATE_INEFFECTIVE IS NULL;
119:
120: INSERT INTO FA_BOOKS_MRC_V (
121: BOOK_TYPE_CODE, ASSET_ID,
122: DATE_PLACED_IN_SERVICE, DATE_EFFECTIVE,
123: DEPRN_START_DATE, DEPRN_METHOD_CODE,
124: LIFE_IN_MONTHS, RATE_ADJUSTMENT_FACTOR,

Line 1148: from fa_books_mrc_v bk

1144: fin_info.cost - bk.allowed_deprn_limit_amount)),
1145: fin_info.cost * bk.allowed_deprn_limit),
1146: bk.formula_factor
1147: into fin_info.old_cost, fin_info.adj_rec_cost, fin_info.formula_factor
1148: from fa_books_mrc_v bk
1149: where bk.asset_id = fin_info.asset_id
1150: and bk.book_type_code = fin_info.book
1151: and bk.date_ineffective is NULL;
1152: