APPS.FA_RX_GROUP dependencies on FA_DEPRN_PERIODS

Line 260: FROM fa_deprn_periods

256: SELECT MIN(period_counter),
257: MAX(period_counter)
258: INTO l_info_rec.min_period_counter,
259: l_info_rec.max_period_counter
260: FROM fa_deprn_periods
261: WHERE book_type_code = p_book_type_code
262: AND fiscal_year = l_info_rec.fiscal_year
263: AND NVL(deprn_run, 'N') = 'Y';
264:

Line 538: fa_deprn_periods dp

534: FROM fa_books bk,
535: fa_books bk_old,
536: fa_transaction_headers fth,
537: fa_book_controls bc,
538: fa_deprn_periods dp
539: WHERE bk.transaction_header_id_in = fth.transaction_header_id
540: AND bk_old.transaction_header_id_out = fth.transaction_header_id
541: AND fth.ASSET_ID = l_group_rec.asset_id
542: AND fth.TRANSACTION_KEY = 'GC'

Line 975: fa_deprn_periods dp,

971: fa_books bk,
972: fa_categories_b cat,
973: fa_deprn_basis_rules br,
974: fa_methods met,
975: fa_deprn_periods dp,
976: fa_deprn_summary ds,
977: ( SELECT bk_pre.asset_id,
978: bk_pre.group_asset_id,
979: bk_pre.cost,

Line 984: fa_deprn_periods dp_pre,

980: bk_pre.cip_cost,
981: ds_pre.deprn_reserve
982: FROM fa_books bk_pre,
983: fa_deprn_summary ds_pre,
984: fa_deprn_periods dp_pre,
985: fa_additions ad_pre
986: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
987: AND dp_pre.book_type_code = bk_pre.book_type_code
988: AND dp_pre.period_counter + 1 = ' || p_info_rec.min_period_counter || '