APPS.FA_TRACK_MEMBER_PVT dependencies on FA_MC_BOOKS_SUMMARY

Line 3010: UPDATE FA_MC_BOOKS_SUMMARY

3006: l_unplanned_exp_tbl(l_count) := l_unplanned_exp_tbl(l_count) + l_unplanned_exp_mem_tbl(l_count);
3007: end loop;
3008:
3009: FORALL l_count IN 1..l_mem_asset_id_tbl.count
3010: UPDATE FA_MC_BOOKS_SUMMARY
3011: SET DEPRN_AMOUNT = l_unplanned_exp_tbl(l_count) + DEPRN_AMOUNT,
3012: YTD_DEPRN = l_unplanned_exp_tbl(l_count) + YTD_DEPRN
3013: WHERE BOOK_TYPE_CODE = h_book_type_code
3014: AND PERIOD_COUNTER = h_period_counter

Line 8968: from FA_MC_BOOKS_SUMMARY

8964: -- EOFY_SALVAGE_VALULE,
8965: EOFY_RESERVE,
8966: SYSTEM_DEPRN_AMOUNT,
8967: SYSTEM_BONUS_DEPRN_AMOUNT
8968: from FA_MC_BOOKS_SUMMARY
8969: where book_type_code = h_book_type_code
8970: and asset_id = h_group_asset_id
8971: and period_counter = p_period_counter
8972: and set_of_books_id = h_set_of_books_id;

Line 8986: from FA_MC_BOOKS_SUMMARY

8982:
8983: cursor GET_GROUP_SYSTEM_INFO_MRC(p_fiscal_year number, p_period_counter_end number) is
8984: select sum(nvl(SYSTEM_DEPRN_AMOUNT,0)),
8985: sum(nvl(SYSTEM_BONUS_DEPRN_AMOUNT,0))
8986: from FA_MC_BOOKS_SUMMARY
8987: where book_type_code = h_book_type_code
8988: and asset_id = h_group_asset_id
8989: and fiscal_year = p_fiscal_year
8990: and period_counter <= p_period_counter_end

Line 9006: from FA_MC_BOOKS_SUMMARY

9002:
9003: cursor GET_GROUP_SALVAGE_MRC(p_fiscal_year number, p_period_num number) is
9004: select SALVAGE_VALUE,
9005: RECOVERABLE_COST
9006: from FA_MC_BOOKS_SUMMARY
9007: where book_type_code = h_book_type_code
9008: and asset_id = h_group_asset_id
9009: and fiscal_year = p_fiscal_year
9010: and period_num = p_period_num

Line 9042: from FA_MC_BOOKS_SUMMARY

9038: BONUS_DEPRN_RESERVE,
9039: YTD_DEPRN,
9040: BONUS_YTD_DEPRN,
9041: EOFY_RESERVE
9042: from FA_MC_BOOKS_SUMMARY
9043: where book_type_code = h_book_type_code
9044: and group_asset_id = h_group_asset_id
9045: and period_counter = h_processing_period_counter -1
9046: and asset_id = h_member_asset_id

Line 11385: MERGE INTO FA_MC_BOOKS_SUMMARY BS

11381: end loop;
11382:
11383: if p_mrc_sob_type_code = 'R' then
11384: forall j in 1..l_tbl_member_asset_id.COUNT
11385: MERGE INTO FA_MC_BOOKS_SUMMARY BS
11386: USING (SELECT
11387: l_tbl_group_asset_id(j) as group_asset_id,
11388: l_tbl_member_asset_id(j) as member_asset_id,
11389: l_tbl_period_counter(j) as period_counter,