APPS.FA_MASS_DEPRN_BASIS_PKG dependencies on FA_BOOKS

Line 128: fa_books bks,

124: FA_STD_TYPES.FAD_DBR_POLISH_5,
125: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
126: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
127: from fa_deprn_summary ds,
128: fa_books bks,
129: fa_methods mt,
130: fa_deprn_rule_details drd,
131: fa_additions_b ad
132: where ds.book_type_code = p_book_type_code

Line 191: fa_books_mrc_v bks,

187: FA_STD_TYPES.FAD_DBR_POLISH_5,
188: FA_STD_TYPES.FAD_DBR_POLISH_NONE)
189: , nvl(mt.guarantee_rate_method_flag, 'NO') -- Bug 6665510: FP: Japan Tax Reform Project
190: from fa_deprn_summary_mrc_v ds,
191: fa_books_mrc_v bks,
192: fa_methods mt,
193: fa_deprn_rule_details drd,
194: fa_additions_b ad
195: where ds.book_type_code = p_book_type_code

Line 451: -- Update fa_books with the new values. Business rules are:

447: end if; -- if ((l_eofy_flag = 'N') and -- Bug4940246
448:
449: end loop;
450:
451: -- Update fa_books with the new values. Business rules are:
452: -- 1. Do not update fa_books for any value if polish asset
453: -- 2. Only update eop_adj_cost, eop_formula_factor, adjusted_capacity,
454: -- old_adjusted_capacity if period_update_flag or
455: -- exclude_fully_reserve_flag is Yes

Line 452: -- 1. Do not update fa_books for any value if polish asset

448:
449: end loop;
450:
451: -- Update fa_books with the new values. Business rules are:
452: -- 1. Do not update fa_books for any value if polish asset
453: -- 2. Only update eop_adj_cost, eop_formula_factor, adjusted_capacity,
454: -- old_adjusted_capacity if period_update_flag or
455: -- exclude_fully_reserve_flag is Yes
456: -- 3. Only update eofy_adj_cost and eofy_formula_factor if eofy_flag

Line 478: update fa_books_mrc_v

474:
475: if (l_eofy_flag = 'Y') then
476:
477: forall i IN 1..l_asset_id_tbl.count
478: update fa_books_mrc_v
479: set adjusted_cost = decode (l_polish_rule_tbl(i),
480: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
481: nvl(l_new_adjusted_cost_tbl(i), 0),
482: l_old_adjusted_cost_tbl(i)),

Line 532: update fa_books_mrc_v

528:
529: else
530:
531: forall i IN 1..l_asset_id_tbl.count
532: update fa_books_mrc_v
533: set adjusted_cost = decode (l_polish_rule_tbl(i),
534: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
535: nvl(l_new_adjusted_cost_tbl(i), 0),
536: l_old_adjusted_cost_tbl(i)),

Line 581: update fa_books

577: end if;
578: if (l_eofy_flag = 'Y') then
579:
580: forall i IN 1..l_asset_id_tbl.count
581: update fa_books
582: set adjusted_cost = decode (l_polish_rule_tbl(i),
583: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
584: nvl(l_new_adjusted_cost_tbl(i), 0),
585: l_old_adjusted_cost_tbl(i)),

Line 640: update fa_books

636: ,p_log_level_rec => g_log_level_rec);
637: end if;
638:
639: forall i IN 1..l_asset_id_tbl.count
640: update fa_books
641: set adjusted_cost = decode (l_polish_rule_tbl(i),
642: FA_STD_TYPES.FAD_DBR_POLISH_NONE,
643: nvl(l_new_adjusted_cost_tbl(i), 0),
644: l_old_adjusted_cost_tbl(i)),

Line 730: update fa_books

726: end if; -- if l_guarantee_rate_flag_tbl
727: end loop;
728:
729: forall i IN 1..l_bks_rowid_tbl.count
730: update fa_books
731: set rate_in_use = l_rate_in_use_tbl(i)
732: where rowid = l_bks_rowid_tbl(i)
733: and l_guarantee_rate_flag_tbl(i) = 'YES';
734: