APPS.FA_MC_UPG2_PKG dependencies on FA_DEPRN_PERIODS

Line 1190: fa_deprn_periods dp,

1186: mrt.cost_of_removal,
1187: maj.transaction_header_id
1188: FROM
1189: fa_mc_adjustments maj,
1190: fa_deprn_periods dp,
1191: fa_mc_retirements mrt,
1192: fa_retirements rt,
1193: fa_mc_conversion_rates cr
1194: WHERE

Line 1622: fa_deprn_periods dp

1618:
1619: SELECT dp.period_num
1620: INTO l_period_num
1621: FROM
1622: fa_deprn_periods dp
1623: WHERE dp.book_type_code = p_book_type_code AND
1624: period_counter = p_end_pc;
1625:
1626: -- if current open period is the first period of fiscal year

Line 1814: fa_deprn_periods dp,

1810: p_mau) * p_mau),
1811: ds.deprn_reserve
1812: FROM
1813: fa_deprn_summary ds,
1814: fa_deprn_periods dp,
1815: fa_mc_books mcbk,
1816: fa_books bk,
1817: fa_mc_conversion_rates cr
1818: WHERE

Line 1971: fa_deprn_periods dp,

1967: p_mau) * p_mau),
1968: 'Y'
1969: FROM
1970: fa_deprn_summary ds,
1971: fa_deprn_periods dp,
1972: fa_mc_books mcbk,
1973: fa_books bk,
1974: fa_mc_conversion_rates cr
1975: WHERE

Line 2244: fa_deprn_periods dp,

2240: p_mau) * p_mau),
2241: 'Y'
2242: FROM
2243: fa_deprn_summary ds,
2244: fa_deprn_periods dp,
2245: fa_mc_books mcbk,
2246: fa_books bk,
2247: fa_mc_conversion_rates cr
2248: WHERE

Line 2361: index(dp fa_deprn_periods_u3)

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) */
2365: dd.book_type_code,

Line 2427: fa_deprn_periods dp,

2423: dd.deprn_run_date
2424: FROM
2425: fa_mc_deprn_summary ds,
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,

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

2695: p_book_type_code IN VARCHAR2,
2696: p_start_pc IN NUMBER,
2697: p_end_pc IN NUMBER) IS
2698: /* ************************************************************************
2699: This procedure will convert fa_deprn_periods records for the Primary
2700: Book to the reporting book. All existing records in fa_mc_deprn_periods
2701: for the reporting book are first deleted. To preserve the trail as to
2702: when the reporting book was first set up, fa_deprn_period rows will be
2703: fetched using the first period counter in fa_mc_deprn_periods all the

Line 2713: 'Converting FA_DEPRN_PERIODS records',

2709: l_pc number;
2710: BEGIN
2711: if (g_print_debug) then
2712: fa_debug_pkg.add('convert_assets',
2713: 'Converting FA_DEPRN_PERIODS records',
2714: 'start');
2715: end if;
2716:
2717: SELECT min(period_counter)

Line 2782: fa_deprn_periods dp

2778: dp.cip_transfer_batch_id,
2779: dp.reval_batch_id,
2780: dp.deprn_adjustment_batch_id
2781: FROM
2782: fa_deprn_periods dp
2783: WHERE
2784: dp.book_type_code = p_book_type_code AND
2785: dp.period_counter between l_pc and p_end_pc;
2786:

Line 2789: 'Converted FA_DEPRN_PERIODS records',

2785: dp.period_counter between l_pc and p_end_pc;
2786:
2787: if (g_print_debug) then
2788: fa_debug_pkg.add('convert_assets',
2789: 'Converted FA_DEPRN_PERIODS records',
2790: 'success');
2791: end if;
2792:
2793: EXCEPTION