APPS.FA_RX_GROUP dependencies on FA_ADDITIONS

Line 483: FROM fa_books bk, fa_additions ad

479: AND NVL(l_group_rec.rule_name, ' ') = FA_RXGA_POSITIVE_REDUCTION THEN
480:
481: SELECT COUNT(*)
482: INTO l_non_cip_num
483: FROM fa_books bk, fa_additions ad
484: WHERE bk.book_type_code = p_book_type_code
485: AND bk.group_asset_id = l_group_rec.asset_id
486: AND ad.asset_type <> 'CIP'
487: AND bk.asset_id = ad.asset_id;

Line 764: fa_additions ad,

760: -- If there was no depreciation calculation in the previous year,
761: -- subquery gets the max period counter prior to the fiscal year.
762:
763: x_sql_stmt := ' FROM
764: fa_additions ad,
765: fa_books bk,
766: fa_categories_b cat,
767: fa_deprn_basis_rules br,
768: fa_methods met,

Line 779: fa_additions ad_pre

775: ds_pre.deprn_reserve
776: FROM fa_books bk_pre,
777: fa_deprn_summary ds_pre,
778: fa_deprn_periods dp_pre,
779: fa_additions ad_pre
780: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
781: AND dp_pre.book_type_code = bk_pre.book_type_code
782: AND dp_pre.period_counter + 1 = ' || p_info_rec.min_period_counter || '
783: AND dp_pre.period_close_date BETWEEN bk_pre.date_effective