2356: CURSOR dd_row IS
2357: SELECT /*+ ordered leading(cr)
2358: index(ds fa_mc_deprn_summary_u1)
2359: index(dd fa_deprn_detail_n1)
2360: index(dh fa_distribution_history_u1)
2361: index(dp fa_deprn_periods_u3)
2362: index(bk fa_books_n1)
2363: index(mcbk fa_mc_books_u1)
2364: index(ah fa_asset_history_n2) */
2426: fa_deprn_detail dd,
2427: fa_deprn_periods dp,
2428: fa_books bk,
2429: fa_mc_books mcbk,
2430: fa_distribution_history dh,
2431: fa_asset_history ah,
2432: fa_mc_conversion_rates cr
2433: WHERE
2434: cr.status = 'S' AND