[Home] [Help]
2200: fadp.period_counter
2201: FROM
2202: fa_distribution_history fadh,
2203: fa_deprn_detail fadd,
2204: fa_deprn_periods fadp,
2205: fa_adjustments faadj
2206: WHERE
2207: fadd.asset_id = h_asset_id
2208: AND fadd.distribution_id = fadh.distribution_id
2245: nvl(faadj.source_type_code, 'DEPRECIATION'),
2246: fadp.period_counter
2247: FROM
2248: fa_distribution_history fadh,
2249: fa_deprn_periods fadp,
2250: fa_adjustments faadj
2251: WHERE
2252: fadp.period_num = h_i
2253: AND fadp.book_type_code = h_book
2301: fadp.period_counter
2302: FROM
2303: fa_distribution_history fadh,
2304: fa_deprn_detail_mrc_v fadd,
2305: fa_deprn_periods fadp,
2306: fa_adjustments_mrc_v faadj
2307: WHERE
2308: fadd.asset_id = h_asset_id
2309: AND fadd.distribution_id = fadh.distribution_id
2346: nvl(faadj.source_type_code, 'DEPRECIATION'),
2347: fadp.period_counter
2348: FROM
2349: fa_distribution_history fadh,
2350: fa_deprn_periods fadp,
2351: fa_adjustments_mrc_v faadj
2352: WHERE
2353: fadp.period_num = h_i
2354: AND fadp.book_type_code = h_book
2445: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2446: h_Brow_deprn_reserve /*Bug 7595090 added this variable to get initial depreciation reserve*/
2447: FROM
2448: fa_deprn_summary ds,
2449: fa_deprn_periods dp
2450: WHERE
2451: ds.asset_id = h_asset_id
2452: AND ds.book_type_code = h_book
2453: AND ds.deprn_source_code = 'BOOKS'
2461: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2462: h_Brow_deprn_reserve /*Bug 7595090 added this variable to get initial depreciation reserve*/
2463: FROM
2464: fa_deprn_summary_mrc_v ds,
2465: fa_deprn_periods dp
2466: WHERE
2467: ds.asset_id = h_asset_id
2468: AND ds.book_type_code = h_book
2469: AND ds.deprn_source_code = 'BOOKS'
2516:
2517: SELECT count(*)
2518: INTO h_ret_count
2519: FROM
2520: fa_deprn_periods fadp,
2521: fa_adjustments faadj
2522: WHERE
2523: fadp.period_num = h_i
2524: AND fadp.book_type_code = h_book
2532:
2533: SELECT count(*)
2534: INTO h_adj_count
2535: FROM
2536: fa_deprn_periods fadp,
2537: fa_adjustments faadj
2538: WHERE
2539: fadp.period_num = h_i
2540: AND fadp.book_type_code = h_book
2550:
2551: SELECT count(*)
2552: INTO h_ret_count
2553: FROM
2554: fa_deprn_periods fadp,
2555: fa_adjustments_mrc_v faadj
2556: WHERE
2557: fadp.period_num = h_i
2558: AND fadp.book_type_code = h_book
2566:
2567: SELECT count(*)
2568: INTO h_adj_count
2569: FROM
2570: fa_deprn_periods fadp,
2571: fa_adjustments_mrc_v faadj
2572: WHERE
2573: fadp.period_num = h_i
2574: AND fadp.book_type_code = h_book
2587: h_prior_pd_tfr := 0;
2588:
2589: SELECT count(*)
2590: INTO h_prior_pd_tfr
2591: FROM fa_deprn_periods dp1,
2592: fa_deprn_periods dp2,
2593: fa_transaction_headers th
2594: WHERE th.asset_id = h_asset_id
2595: AND th.book_type_code = h_book
2588:
2589: SELECT count(*)
2590: INTO h_prior_pd_tfr
2591: FROM fa_deprn_periods dp1,
2592: fa_deprn_periods dp2,
2593: fa_transaction_headers th
2594: WHERE th.asset_id = h_asset_id
2595: AND th.book_type_code = h_book
2596: AND th.transaction_type_code = 'TRANSFER'
2794:
2795: SELECT count(*)
2796: INTO h_curr_pd_add
2797: FROM
2798: fa_deprn_periods dp,
2799: fa_transaction_headers th
2800: WHERE th.asset_id = h_asset_id
2801: AND th.book_type_code = h_book
2802: AND th.transaction_type_code || '' = 'ADDITION'
2814: SELECT sum(adjustment_amount)--bug fix 3905436
2815: INTO h_adj_exp_row
2816: FROM
2817: fa_adjustments adj,
2818: fa_deprn_periods dp,
2819: fa_transaction_headers th
2820: WHERE
2821: th.asset_id = h_asset_id
2822: AND th.book_type_code = h_book
2843: SELECT PRIOR_FY_EXPENSE
2844: INTO h_prior_fy_exp
2845: FROM
2846: fa_deprn_summary ds,
2847: fa_deprn_periods dp,
2848: fa_transaction_headers th
2849: WHERE
2850: th.asset_id = h_asset_id
2851: AND th.book_type_code = h_book
2896: SELECT sum(adjustment_amount), max(th.transaction_header_id)
2897: INTO h_adj_exp_row, h_old_reinst_trx_id
2898: FROM
2899: fa_adjustments adj,
2900: fa_deprn_periods dp,
2901: fa_transaction_headers th
2902: WHERE
2903: th.asset_id = h_asset_id
2904: AND th.book_type_code = h_book
2926: ,dp2.period_counter
2927: into h_old_reinst_pc
2928: ,h_old_ret_pc
2929: from fa_transaction_headers trx,
2930: fa_deprn_periods dp1,
2931: fa_retirements old_ret,
2932: fa_deprn_periods dp2
2933: where trx.transaction_header_id = h_old_reinst_trx_id
2934: and dp1.book_type_code = trx.book_type_code
2928: ,h_old_ret_pc
2929: from fa_transaction_headers trx,
2930: fa_deprn_periods dp1,
2931: fa_retirements old_ret,
2932: fa_deprn_periods dp2
2933: where trx.transaction_header_id = h_old_reinst_trx_id
2934: and dp1.book_type_code = trx.book_type_code
2935: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE
2936: and dp1.CALENDAR_PERIOD_CLOSE_DATE
2943: select dp.period_counter
2944: into h_ret_prorate_pc
2945: from fa_retirements new_ret
2946: ,fa_conventions conv
2947: ,fa_deprn_periods dp
2948: where new_ret.transaction_header_id_in=ret.th_id_in
2949: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
2950: and new_ret.date_retired between conv.start_date and conv.end_date
2951: and dp.book_type_code = new_ret.book_type_code
3325: begin
3326: SELECT pcal.period_num
3327: INTO h_start_pd_endpp
3328: FROM fa_calendar_periods pcal,
3329: fa_deprn_periods dp
3330: WHERE calendar_type = p_cal
3331: AND dp.book_type_code = h_book
3332: AND dp.fiscal_year = h_current_fiscal_yr
3333: AND dp.period_num = h_start_pdnum
4077:
4078: EXEC SQL
4079: SELECT to_number (to_char (dp.calendar_period_open_date, 'J'))
4080: INTO :h_cpp_jstartdate
4081: FROM fa_deprn_periods dp
4082: WHERE dp.book_type_code = :h_book
4083: AND dp.fiscal_year = :h_current_fiscal_yr
4084: AND dp.period_num = :h_work_pdnum;
4085: */
4135: between start_date and end_date;
4136:
4137: SELECT to_number (to_char (dp.calendar_period_open_date, 'J'))
4138: INTO h_cpp_jenddate
4139: FROM fa_deprn_periods dp
4140: WHERE dp.book_type_code = h_book
4141: AND dp.fiscal_year = h_current_fiscal_yr
4142: AND dp.period_num = h_stop_pdnum;
4143: