DBA Data[Home] [Help]

APPS.FA_RX_GROUP dependencies on FA_MC_DEPRN_PERIODS

Line 578: fa_mc_deprn_periods dp

574: fa_mc_books bk_old,
575: fa_transaction_headers fth,
576: fa_mc_book_controls bc,
577: fa_book_controls bc1,
578: fa_mc_deprn_periods dp
579: WHERE bk.transaction_header_id_in = fth.transaction_header_id
580: AND bk_old.transaction_header_id_out = fth.transaction_header_id
581: AND fth.ASSET_ID = l_group_rec.asset_id
582: AND fth.TRANSACTION_KEY = 'GC'

Line 1009: fa_mc_deprn_periods dp,

1005: fa_mc_books bk,
1006: fa_categories_b cat,
1007: fa_deprn_basis_rules br,
1008: fa_methods met,
1009: fa_mc_deprn_periods dp,
1010: fa_mc_deprn_summary ds,
1011: ( SELECT bk_pre.asset_id,
1012: bk_pre.group_asset_id,
1013: bk_pre.cost,

Line 1018: fa_mc_deprn_periods dp_pre,

1014: bk_pre.cip_cost,
1015: ds_pre.deprn_reserve
1016: FROM fa_mc_books bk_pre,
1017: fa_mc_deprn_summary ds_pre,
1018: fa_mc_deprn_periods dp_pre,
1019: fa_additions ad_pre
1020: WHERE bk_pre.book_type_code = ''' || p_info_rec.book_type_code || '''
1021: AND dp_pre.book_type_code = bk_pre.book_type_code
1022: AND dp_pre.period_counter + 1 = ' || p_info_rec.min_period_counter || '