APPS.FA_RX_GROUP dependencies on FA_DEPRN_PERIODS

Line 189: FROM fa_deprn_periods

185: SELECT MIN(period_counter),
186: MAX(period_counter)
187: INTO l_info_rec.min_period_counter,
188: l_info_rec.max_period_counter
189: FROM fa_deprn_periods
190: WHERE book_type_code = p_book_type_code
191: AND fiscal_year = l_info_rec.fiscal_year
192: AND NVL(deprn_run, 'N') = 'Y';
193:

Line 377: fa_deprn_periods dp_pre

373: (SELECT bk_pre.asset_id,
374: bk_pre.group_asset_id
375: FROM fa_books bk_pre,
376: fa_deprn_summary ds_pre,
377: fa_deprn_periods dp_pre
378: WHERE bk_pre.book_type_code = p_book_type_code
379: AND dp_pre.book_type_code = bk_pre.book_type_code
380: AND dp_pre.period_counter + 1 = l_info_rec.min_period_counter
381: AND dp_pre.period_close_date BETWEEN bk_pre.date_effective

Line 769: fa_deprn_periods dp,

765: fa_books bk,
766: fa_categories_b cat,
767: fa_deprn_basis_rules br,
768: fa_methods met,
769: fa_deprn_periods dp,
770: fa_deprn_summary ds,
771: ( SELECT bk_pre.asset_id,
772: bk_pre.group_asset_id,
773: bk_pre.cost,

Line 778: fa_deprn_periods dp_pre,

774: bk_pre.cip_cost,
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 || '