APPS.FA_TRACK_MEMBER_PVT dependencies on FA_BOOKS_SUMMARY_MRC_V

Line 2853: UPDATE FA_BOOKS_SUMMARY_MRC_V

2849: WHERE BOOK_TYPE_CODE = h_book_type_code
2850: AND PERIOD_COUNTER = h_period_counter
2851: AND ASSET_ID = h_unplanned_member_asset;
2852: else
2853: UPDATE FA_BOOKS_SUMMARY_MRC_V
2854: SET DEPRN_AMOUNT = h_unplanned_expense + DEPRN_AMOUNT,
2855: YTD_DEPRN = h_unplanned_expense + YTD_DEPRN
2856: WHERE BOOK_TYPE_CODE = h_book_type_code
2857: AND PERIOD_COUNTER = h_period_counter

Line 8694: from FA_BOOKS_SUMMARY_MRC_V

8690: -- EOFY_SALVAGE_VALULE,
8691: EOFY_RESERVE,
8692: SYSTEM_DEPRN_AMOUNT,
8693: SYSTEM_BONUS_DEPRN_AMOUNT
8694: from FA_BOOKS_SUMMARY_MRC_V
8695: where book_type_code = h_book_type_code
8696: and asset_id = h_group_asset_id
8697: and period_counter = p_period_counter;
8698:

Line 8711: from FA_BOOKS_SUMMARY_MRC_V

8707:
8708: cursor GET_GROUP_SYSTEM_INFO_MRC(p_fiscal_year number, p_period_counter_end number) is
8709: select sum(nvl(SYSTEM_DEPRN_AMOUNT,0)),
8710: sum(nvl(SYSTEM_BONUS_DEPRN_AMOUNT,0))
8711: from FA_BOOKS_SUMMARY_MRC_V
8712: where book_type_code = h_book_type_code
8713: and asset_id = h_group_asset_id
8714: and fiscal_year = p_fiscal_year
8715: and period_counter <= p_period_counter_end;

Line 8730: from FA_BOOKS_SUMMARY_MRC_V

8726:
8727: cursor GET_GROUP_SALVAGE_MRC(p_fiscal_year number, p_period_num number) is
8728: select SALVAGE_VALUE,
8729: RECOVERABLE_COST
8730: from FA_BOOKS_SUMMARY_MRC_V
8731: where book_type_code = h_book_type_code
8732: and asset_id = h_group_asset_id
8733: and fiscal_year = p_fiscal_year
8734: and period_num = p_period_num;

Line 8765: from FA_BOOKS_SUMMARY_MRC_V

8761: BONUS_DEPRN_RESERVE,
8762: YTD_DEPRN,
8763: BONUS_YTD_DEPRN,
8764: EOFY_RESERVE
8765: from FA_BOOKS_SUMMARY_MRC_V
8766: where book_type_code = h_book_type_code
8767: and group_asset_id = h_group_asset_id
8768: and period_counter = h_processing_period_counter -1
8769: and asset_id = h_member_asset_id;

Line 11008: from fa_books_summary_mrc_v

11004: -- and nvl(set_of_books_id, -99) = nvl(h_set_of_books_id, -99);
11005:
11006: cursor CHK_BS_TABLE_MRC is
11007: select 'Y'
11008: from fa_books_summary_mrc_v
11009: where book_type_code = h_book_type_code
11010: -- and group_asset_id = h_group_asset_id
11011: and asset_id = h_member_asset_id
11012: and period_counter = h_period_counter;

Line 11188: UPDATE FA_BOOKS_SUMMARY_MRC_V

11184: if (p_log_level_rec.statement_level) then
11185: fa_debug_pkg.add(l_calling_fn, 'Inserted new row for', h_member_asset_id||':'||h_period_counter, p_log_level_rec);
11186: end if;
11187: else
11188: UPDATE FA_BOOKS_SUMMARY_MRC_V
11189: SET COST = p_track_member_table(i).cost
11190: , SALVAGE_VALUE = p_track_member_table(i).salvage_value
11191: , RECOVERABLE_COST = p_track_member_table(i).recoverable_cost
11192: , ADJUSTED_RECOVERABLE_COST = p_track_member_table(i).adjusted_recoverable_cost