eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_DEPRN_PERIODS

Line 2425: fa_deprn_periods fadp,

2421: faadj.transaction_header_id
2422: FROM
2423: fa_distribution_history fadh,
2424: fa_deprn_detail fadd,
2425: fa_deprn_periods fadp,
2426: fa_adjustments faadj
2427: WHERE
2428: fadd.asset_id = h_asset_id
2429: AND fadd.distribution_id = fadh.distribution_id

Line 2473: fa_deprn_periods fadp,

2469: fadp.period_counter,
2470: faadj.transaction_header_id
2471: FROM
2472: fa_distribution_history fadh,
2473: fa_deprn_periods fadp,
2474: fa_adjustments faadj
2475: WHERE
2476: fadp.period_num = h_i
2477: AND fadp.book_type_code = h_book

Line 2535: fa_deprn_periods fadp,

2531: faadj.transaction_header_id
2532: FROM
2533: fa_distribution_history fadh,
2534: fa_mc_deprn_detail fadd,
2535: fa_deprn_periods fadp,
2536: fa_mc_adjustments faadj
2537: WHERE
2538: fadd.asset_id = h_asset_id
2539: AND fadd.distribution_id = fadh.distribution_id

Line 2585: fa_deprn_periods fadp,

2581: fadp.period_counter,
2582: faadj.transaction_header_id
2583: FROM
2584: fa_distribution_history fadh,
2585: fa_deprn_periods fadp,
2586: fa_mc_adjustments faadj
2587: WHERE
2588: fadp.period_num = h_i
2589: AND fadp.book_type_code = h_book

Line 2698: fa_deprn_periods dp

2694: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2695: h_ytd_impairment, h_Brow_deprn_reserve
2696: FROM
2697: fa_deprn_summary ds,
2698: fa_deprn_periods dp
2699: WHERE
2700: ds.asset_id = h_asset_id
2701: AND ds.book_type_code = h_book
2702: AND ds.deprn_source_code = 'BOOKS'

Line 2714: fa_deprn_periods dp

2710: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2711: h_ytd_impairment, h_Brow_deprn_reserve
2712: FROM
2713: fa_mc_deprn_summary ds,
2714: fa_deprn_periods dp
2715: WHERE
2716: ds.asset_id = h_asset_id
2717: AND ds.book_type_code = h_book
2718: AND ds.deprn_source_code = 'BOOKS'

Line 2761: fa_deprn_periods fadp,

2757:
2758: SELECT count(*)
2759: INTO h_ret_count
2760: FROM
2761: fa_deprn_periods fadp,
2762: fa_adjustments faadj
2763: WHERE
2764: fadp.period_num = h_i
2765: AND fadp.book_type_code = h_book

Line 2777: fa_deprn_periods fadp,

2773:
2774: SELECT count(*)
2775: INTO h_adj_count
2776: FROM
2777: fa_deprn_periods fadp,
2778: fa_adjustments faadj
2779: WHERE
2780: fadp.period_num = h_i
2781: AND fadp.book_type_code = h_book

Line 2795: fa_deprn_periods fadp,

2791:
2792: SELECT count(*)
2793: INTO h_ret_count
2794: FROM
2795: fa_deprn_periods fadp,
2796: fa_mc_adjustments faadj
2797: WHERE
2798: fadp.period_num = h_i
2799: AND fadp.book_type_code = h_book

Line 2812: fa_deprn_periods fadp,

2808:
2809: SELECT count(*)
2810: INTO h_adj_count
2811: FROM
2812: fa_deprn_periods fadp,
2813: fa_mc_adjustments faadj
2814: WHERE
2815: fadp.period_num = h_i
2816: AND fadp.book_type_code = h_book

Line 2834: FROM fa_deprn_periods dp1,

2830: h_prior_pd_tfr := 0;
2831:
2832: SELECT count(*)
2833: INTO h_prior_pd_tfr
2834: FROM fa_deprn_periods dp1,
2835: fa_deprn_periods dp2,
2836: fa_transaction_headers th
2837: WHERE th.asset_id = h_asset_id
2838: AND th.book_type_code = h_book

Line 2835: fa_deprn_periods dp2,

2831:
2832: SELECT count(*)
2833: INTO h_prior_pd_tfr
2834: FROM fa_deprn_periods dp1,
2835: fa_deprn_periods dp2,
2836: fa_transaction_headers th
2837: WHERE th.asset_id = h_asset_id
2838: AND th.book_type_code = h_book
2839: AND th.transaction_type_code = 'TRANSFER'

Line 2953: fa_deprn_periods dp

2949: select 'Y'
2950: into l_same_year
2951: from fa_transaction_headers th,
2952: fa_fiscal_year fy,
2953: fa_deprn_periods dp
2954: where th.asset_id = h_asset_id
2955: and th.book_type_code = h_book
2956: and dp.book_type_code = th.book_type_code
2957: and th.transaction_type_code = 'ADDITION'

Line 2991: fa_deprn_periods dp

2987: select to_char(trunc(dp.calendar_period_open_date),'J')-
2988: to_char(trunc(th.transaction_date_entered),'J')
2989: into l_tot_days
2990: from fa_transaction_headers th,
2991: fa_deprn_periods dp
2992: where th.asset_id = h_asset_id
2993: and th.book_type_code = h_book
2994: and th.transaction_type_code = 'ADDITION'
2995: and dp.book_type_code = th.book_type_code

Line 3030: fa_deprn_periods dp

3026: select 'Y'
3027: into l_same_deprn_start_yr
3028: from fa_transaction_headers th,
3029: fa_fiscal_year fy,
3030: fa_deprn_periods dp
3031: where th.asset_id = h_asset_id
3032: and th.book_type_code = h_book
3033: and dp.book_type_code = th.book_type_code
3034: and th.transaction_type_code = 'ADDITION'

Line 3179: fa_deprn_periods dp,

3175: begin
3176: select 'Y'
3177: into l_same_year
3178: from fa_transaction_headers th,
3179: fa_deprn_periods dp,
3180: fa_fiscal_year ffy
3181: where th.asset_id = h_asset_id
3182: and th.book_type_code = h_book
3183: and th.transaction_type_code = 'ADDITION'

Line 3217: fa_deprn_periods dp,

3213: select to_char(trunc(dp.calendar_period_open_date),'J')-
3214: to_char(trunc(th.transaction_date_entered),'J')
3215: into l_tot_days
3216: from fa_transaction_headers th,
3217: fa_deprn_periods dp,
3218: fa_fiscal_year ffy
3219: where th.asset_id = h_asset_id
3220: and th.book_type_code = h_book
3221: and th.transaction_type_code = 'ADDITION'

Line 3484: fa_deprn_periods dp,

3480:
3481: SELECT count(*)
3482: INTO h_curr_pd_add
3483: FROM
3484: fa_deprn_periods dp,
3485: fa_transaction_headers th
3486: WHERE th.asset_id = h_asset_id
3487: AND th.book_type_code = h_book
3488: AND th.transaction_type_code || '' = 'ADDITION'

Line 3504: fa_deprn_periods dp,

3500:
3501: SELECT count(*)
3502: INTO h_curr_pd_reinst
3503: FROM
3504: fa_deprn_periods dp,
3505: fa_transaction_headers th
3506: WHERE th.asset_id = h_asset_id
3507: AND th.book_type_code = h_book
3508: AND th.transaction_type_code || '' = 'REINSTATEMENT'

Line 3543: fa_deprn_periods dp,

3539: SELECT sum(nvl(adjustment_amount,0))--bug fix 3905436
3540: INTO h_adj_exp_row
3541: FROM
3542: fa_adjustments adj,
3543: fa_deprn_periods dp,
3544: fa_transaction_headers th
3545: WHERE
3546: th.asset_id = h_asset_id
3547: AND th.book_type_code = h_book

Line 3567: fa_deprn_periods dp,

3563: SELECT sum(nvl(adjustment_amount,0))--bug fix 3905436
3564: INTO h_adj_exp_row
3565: FROM
3566: fa_mc_adjustments adj,
3567: fa_deprn_periods dp,
3568: fa_transaction_headers th
3569: WHERE
3570: th.asset_id = h_asset_id
3571: AND th.book_type_code = h_book

Line 3608: fa_deprn_periods dp,

3604: SELECT PRIOR_FY_EXPENSE
3605: INTO h_prior_fy_exp
3606: FROM
3607: fa_deprn_summary ds,
3608: fa_deprn_periods dp,
3609: fa_transaction_headers th
3610: WHERE
3611: th.asset_id = h_asset_id
3612: AND th.book_type_code = h_book

Line 3636: fa_deprn_periods dp,

3632: SELECT PRIOR_FY_EXPENSE
3633: INTO h_prior_fy_exp
3634: FROM
3635: fa_mc_deprn_summary ds,
3636: fa_deprn_periods dp,
3637: fa_transaction_headers th
3638: WHERE
3639: th.asset_id = h_asset_id
3640: AND th.book_type_code = h_book

Line 3693: fa_deprn_periods dp,

3689: SELECT sum(adjustment_amount), max(th.transaction_header_id)
3690: INTO h_adj_exp_row, h_old_reinst_trx_id
3691: FROM
3692: fa_adjustments adj,
3693: fa_deprn_periods dp,
3694: fa_transaction_headers th
3695: WHERE
3696: th.asset_id = h_asset_id
3697: AND th.book_type_code = h_book

Line 3717: fa_deprn_periods dp,

3713: SELECT sum(adjustment_amount), max(th.transaction_header_id)
3714: INTO h_adj_exp_row, h_old_reinst_trx_id
3715: FROM
3716: fa_mc_adjustments adj,
3717: fa_deprn_periods dp,
3718: fa_transaction_headers th
3719: WHERE
3720: th.asset_id = h_asset_id
3721: AND th.book_type_code = h_book

Line 3752: fa_deprn_periods dp1,

3748: ,dp2.period_counter
3749: into h_old_reinst_pc
3750: ,h_old_ret_pc
3751: from fa_transaction_headers trx,
3752: fa_deprn_periods dp1,
3753: fa_retirements old_ret,
3754: fa_deprn_periods dp2,
3755: fa_conventions conv
3756: where trx.transaction_header_id = h_old_reinst_trx_id

Line 3754: fa_deprn_periods dp2,

3750: ,h_old_ret_pc
3751: from fa_transaction_headers trx,
3752: fa_deprn_periods dp1,
3753: fa_retirements old_ret,
3754: fa_deprn_periods dp2,
3755: fa_conventions conv
3756: where trx.transaction_header_id = h_old_reinst_trx_id
3757: and dp1.book_type_code = trx.book_type_code
3758: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE

Line 3771: ,fa_deprn_periods dp

3767: select dp.period_counter
3768: into h_ret_prorate_pc
3769: from fa_retirements new_ret
3770: ,fa_conventions conv
3771: ,fa_deprn_periods dp
3772: where new_ret.transaction_header_id_in=ret.th_id_in
3773: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
3774: and new_ret.date_retired between conv.start_date and conv.end_date
3775: and dp.book_type_code = new_ret.book_type_code

Line 3787: fa_deprn_periods dp1,

3783: ,dp2.period_counter
3784: into h_old_reinst_pc
3785: ,h_old_ret_pc
3786: from fa_transaction_headers trx,
3787: fa_deprn_periods dp1,
3788: fa_mc_retirements old_ret,
3789: fa_deprn_periods dp2,
3790: fa_conventions conv
3791: where trx.transaction_header_id = h_old_reinst_trx_id

Line 3789: fa_deprn_periods dp2,

3785: ,h_old_ret_pc
3786: from fa_transaction_headers trx,
3787: fa_deprn_periods dp1,
3788: fa_mc_retirements old_ret,
3789: fa_deprn_periods dp2,
3790: fa_conventions conv
3791: where trx.transaction_header_id = h_old_reinst_trx_id
3792: and dp1.book_type_code = trx.book_type_code
3793: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE

Line 3807: ,fa_deprn_periods dp

3803: select dp.period_counter
3804: into h_ret_prorate_pc
3805: from fa_mc_retirements new_ret
3806: ,fa_conventions conv
3807: ,fa_deprn_periods dp
3808: where new_ret.transaction_header_id_in=ret.th_id_in
3809: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
3810: and new_ret.date_retired between conv.start_date and conv.end_date
3811: and new_ret.set_of_books_id = ret.set_of_books_id

Line 4226: fa_deprn_periods dp

4222: begin
4223: SELECT pcal.period_num
4224: INTO h_start_pd_endpp
4225: FROM fa_calendar_periods pcal,
4226: fa_deprn_periods dp
4227: WHERE calendar_type = p_cal
4228: AND dp.book_type_code = h_book
4229: AND dp.fiscal_year = h_current_fiscal_yr
4230: AND dp.period_num = h_start_pdnum

Line 4446: from fa_deprn_periods dp1,

4442:
4443: -- bug#8496694
4444: select decode(dp1.fiscal_year,dp2.fiscal_year,1,0)
4445: into l_same_fy
4446: from fa_deprn_periods dp1,
4447: fa_deprn_periods dp2
4448: where dp1.book_type_code = h_book
4449: and dp2.book_type_code = dp1.book_type_code
4450: and dp1.period_counter = h_asset_addition_pc

Line 4447: fa_deprn_periods dp2

4443: -- bug#8496694
4444: select decode(dp1.fiscal_year,dp2.fiscal_year,1,0)
4445: into l_same_fy
4446: from fa_deprn_periods dp1,
4447: fa_deprn_periods dp2
4448: where dp1.book_type_code = h_book
4449: and dp2.book_type_code = dp1.book_type_code
4450: and dp1.period_counter = h_asset_addition_pc
4451: and dp2.period_counter = h_start_pd_pc;

Line 4460: fa_deprn_periods dp

4456: into l_adj_overlap
4457: from dual
4458: where EXISTS (select 'Ret Overlapping Adj'
4459: from fa_transaction_headers th,
4460: fa_deprn_periods dp
4461: where dp.book_type_code = h_book
4462: and th.book_type_code = h_book
4463: and th.asset_id = h_asset_id
4464: and dp.period_counter = h_start_pd_pc - 1

Line 4590: fa_deprn_periods dp

4586: begin
4587: select pcal.period_num
4588: into h_fully_rsv_pd
4589: from fa_calendar_periods pcal,
4590: fa_deprn_periods dp
4591: where calendar_type = p_cal
4592: and dp.book_type_code = h_book
4593: and dp.fiscal_year = h_current_fiscal_yr
4594: and dp.period_counter = bk.pc_fully_reserved

Line 4662: fa_deprn_periods dp

4658: begin
4659: select count(*)
4660: into h_daily_annual_adj_check
4661: from fa_transaction_headers th,
4662: fa_deprn_periods dp
4663: where dp.book_type_code = h_book
4664: and dp.period_counter = h_start_pd_pc - 1
4665: and th.book_type_code = h_book
4666: and th.asset_id = h_asset_id

Line 4794: fa_deprn_periods dp

4790: begin
4791: select 1
4792: into l_poa_ret
4793: from fa_deprn_summary ds,
4794: fa_deprn_periods dp
4795: where ds.book_type_code = h_book
4796: and ds.asset_id = h_asset_id
4797: and ds.deprn_source_code = 'BOOKS'
4798: and dp.book_type_code = h_book

Line 5403: FROM fa_deprn_periods dp

5399:
5400: EXEC SQL
5401: SELECT to_number (to_char (dp.calendar_period_open_date, 'J'))
5402: INTO :h_cpp_jstartdate
5403: FROM fa_deprn_periods dp
5404: WHERE dp.book_type_code = :h_book
5405: AND dp.fiscal_year = :h_current_fiscal_yr
5406: AND dp.period_num = :h_work_pdnum;
5407: */

Line 5462: FROM fa_deprn_periods dp

5458: between start_date and end_date;
5459:
5460: SELECT to_number (to_char (dp.calendar_period_open_date, 'J'))
5461: INTO h_cpp_jenddate
5462: FROM fa_deprn_periods dp
5463: WHERE dp.book_type_code = h_book
5464: AND dp.fiscal_year = h_current_fiscal_yr
5465: AND dp.period_num = h_stop_pdnum;
5466: