[Home] [Help]
56: select r.retirement_id
57: ,r.units
58: into l_ret_id_in_corp
59: ,l_units_retired
60: from fa_transaction_headers sth
61: ,fa_retirements r
62: ,fa_book_controls bc
63: where sth.transaction_header_id = RET.th_id_in
64: and sth.asset_id = RET.asset_id
88: into l_id_out
89: from fa_distribution_history
90: where retirement_id =
91: (select r.retirement_id
92: from fa_transaction_headers sth
93: ,fa_retirements r
94: where sth.transaction_header_id = RET.th_id_in
95: and sth.asset_id = RET.asset_id
96: and sth.book_type_code = RET.book
565: and adj.period_counter_created = cpd_ctr
566: and adj.adjustment_type = 'COST'
567: and not exists -- check to see if adj.THID is from Corp
568: (select 1
569: from fa_transaction_headers th
570: where th.transaction_header_id = adj.transaction_header_id
571: and th.book_type_code = RET.book
572: and th.asset_id = RET.asset_id
573: )
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'
2840: AND th.date_effective between dp1.period_open_date
2947: --Bug#9739739:Changed query to use fa_fiscal_year
2948: begin
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
2986:
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'
3024: --Bug#9739739: Checking if addition is back_dated to previous fiscal_years
3025: begin
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
3174: else
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
3212: if p_pers_per_yr = 365 then
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
3335:
3336: h_annual_adj_check := 0;
3337: select count(*)
3338: into h_annual_adj_check
3339: from fa_transaction_headers th
3340: where th.transaction_header_id = h_transaction_header_id
3341: and th.transaction_key is null
3342: and nvl(th.transaction_subtype,'XX') = 'EXPENSED';
3343:
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'
3489: AND th.date_effective between dp.period_open_date
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'
3509: AND th.date_effective between dp.period_open_date
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
3548: AND th.transaction_type_code || '' = 'ADDITION'
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
3572: AND th.transaction_type_code || '' = 'ADDITION'
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
3613: AND th.transaction_type_code || '' = 'ADDITION'
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
3641: AND th.transaction_type_code || '' = 'ADDITION'
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
3698: AND th.transaction_type_code || '' = 'REINSTATEMENT'
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
3722: AND th.transaction_type_code || '' = 'REINSTATEMENT'
3747: select dp1.period_counter
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
3782: select dp1.period_counter
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
4455: Select count(*)
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
4492: Select count(*)
4493: into l_adj_overlap
4494: from dual
4495: where EXISTS ( Select 'Ret Overlapping Adj'
4496: from fa_transaction_headers th,
4497: fa_mc_deprn_periods dp
4498: where dp.book_type_code = h_book
4499: and dp.set_of_books_id = ret.set_of_books_id
4500: and th.book_type_code = h_book
4657: if mrc_sob_type_code <> 'R' then
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
4674: else
4675: begin
4676: select count(*)
4677: into h_daily_annual_adj_check
4678: from fa_transaction_headers th,
4679: fa_mc_deprn_periods dp
4680: where dp.book_type_code = h_book
4681: and dp.period_counter = h_start_pd_pc - 1
4682: and dp.set_of_books_id = ret.set_of_books_id