APPS.FA_MC_UPG2_PKG dependencies on FA_DEPRN_PERIODS

Line 1271: fa_deprn_periods dp,

1267: mrt.cost_of_removal,
1268: maj.transaction_header_id
1269: FROM
1270: fa_mc_adjustments maj,
1271: fa_deprn_periods dp,
1272: fa_mc_retirements mrt,
1273: fa_retirements rt,
1274: fa_mc_conversion_rates cr
1275: WHERE

Line 1713: fa_deprn_periods dp

1709:
1710: SELECT dp.period_num
1711: INTO l_period_num
1712: FROM
1713: fa_deprn_periods dp
1714: WHERE dp.book_type_code = p_book_type_code AND
1715: period_counter = p_end_pc;
1716:
1717: -- if current open period is the first period of fiscal year

Line 1907: fa_deprn_periods dp,

1903: ds.deprn_reserve,
1904: ds.deprn_override_flag
1905: FROM
1906: fa_deprn_summary ds,
1907: fa_deprn_periods dp,
1908: fa_mc_books mcbk,
1909: fa_books bk,
1910: fa_mc_conversion_rates cr
1911: WHERE

Line 2066: fa_deprn_periods dp,

2062: 'Y',
2063: ds.deprn_override_flag
2064: FROM
2065: fa_deprn_summary ds,
2066: fa_deprn_periods dp,
2067: fa_mc_books mcbk,
2068: fa_books bk,
2069: fa_mc_conversion_rates cr
2070: WHERE

Line 2344: fa_deprn_periods dp,

2340: 'Y',
2341: ds.deprn_override_flag
2342: FROM
2343: fa_deprn_summary ds,
2344: fa_deprn_periods dp,
2345: fa_mc_books mcbk,
2346: fa_books bk,
2347: fa_mc_conversion_rates cr
2348: WHERE

Line 2467: index(dp fa_deprn_periods_u3)

2463: SELECT /*+ ordered leading(cr)
2464: index(ds fa_mc_deprn_summary_u1)
2465: index(dd fa_deprn_detail_n1)
2466: index(dh fa_distribution_history_u1)
2467: index(dp fa_deprn_periods_u3)
2468: index(bk fa_books_n1)
2469: index(mcbk fa_mc_books_u1)
2470: index(ah fa_asset_history_n2) */
2471: dd.book_type_code,

Line 2539: fa_deprn_periods dp,

2535: dd.reval_reserve_ccid
2536: FROM
2537: fa_mc_deprn_summary ds,
2538: fa_deprn_detail dd,
2539: fa_deprn_periods dp,
2540: fa_books bk,
2541: fa_mc_books mcbk,
2542: fa_distribution_history dh,
2543: fa_asset_history ah,

Line 2830: This procedure will convert fa_deprn_periods records for the Primary

2826: p_book_type_code IN VARCHAR2,
2827: p_start_pc IN NUMBER,
2828: p_end_pc IN NUMBER) IS
2829: /* ************************************************************************
2830: This procedure will convert fa_deprn_periods records for the Primary
2831: Book to the reporting book. All existing records in fa_mc_deprn_periods
2832: for the reporting book are first deleted. To preserve the trail as to
2833: when the reporting book was first set up, fa_deprn_period rows will be
2834: fetched using the first period counter in fa_mc_deprn_periods all the

Line 2844: 'Converting FA_DEPRN_PERIODS records',

2840: l_pc number;
2841: BEGIN
2842: if (g_print_debug) then
2843: fa_debug_pkg.add('convert_assets',
2844: 'Converting FA_DEPRN_PERIODS records',
2845: 'start');
2846: end if;
2847:
2848: SELECT min(period_counter)

Line 2913: fa_deprn_periods dp

2909: dp.cip_transfer_batch_id,
2910: dp.reval_batch_id,
2911: dp.deprn_adjustment_batch_id
2912: FROM
2913: fa_deprn_periods dp
2914: WHERE
2915: dp.book_type_code = p_book_type_code AND
2916: dp.period_counter between l_pc and p_end_pc;
2917:

Line 2920: 'Converted FA_DEPRN_PERIODS records',

2916: dp.period_counter between l_pc and p_end_pc;
2917:
2918: if (g_print_debug) then
2919: fa_debug_pkg.add('convert_assets',
2920: 'Converted FA_DEPRN_PERIODS records',
2921: 'success');
2922: end if;
2923:
2924: EXCEPTION