APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 134: from fa_adjustments_mrc_v

130: and rownum = 1;
131: else
132: select count(*)
133: into l_balance_tfr_in_tax
134: from fa_adjustments_mrc_v
135: where book_type_code = RET.book
136: and asset_id = RET.asset_id
137: and transaction_header_id = l_id_out -- Corp's TRANSFER OUT THID
138: and source_type_code in ('TRANSFER', 'RETIREMENT') -- TRANSFER for part-ret, RETIREMENT for reinst of full retirement

Line 200: from fa_adjustments_mrc_v

196: and transaction_header_id_out is NULL
197: and rownum = 1
198: and distribution_id =
199: (select max(distribution_id)
200: from fa_adjustments_mrc_v
201: where book_type_code = RET.book
202: and asset_id = RET.asset_id
203: -- and source_type_code in ('ADDITION')
204: and adjustment_amount <> 0

Line 624: FROM FA_ADJUSTMENTS_MRC_V

620: SELECT SUM(NVL(DECODE(DEBIT_CREDIT_FLAG,
621: 'CR', ADJUSTMENT_AMOUNT,
622: -1 * ADJUSTMENT_AMOUNT), 0)*
623: DECODE(ADJUSTMENT_TYPE, 'RESERVE', -1, 1))
624: FROM FA_ADJUSTMENTS_MRC_V
625: WHERE (DISTRIBUTION_ID = c_dist_id
626: OR DISTRIBUTION_ID = c_new_dist_id)
627: AND BOOK_TYPE_CODE = ret.book
628: AND PERIOD_COUNTER_CREATED = cpd_ctr

Line 2306: fa_adjustments_mrc_v faadj

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
2310: AND fadd.book_type_code = h_book

Line 2351: fa_adjustments_mrc_v faadj

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
2355: AND fadp.fiscal_year = h_current_fiscal_yr

Line 2555: fa_adjustments_mrc_v faadj

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
2559: AND fadp.fiscal_year = h_current_fiscal_yr

Line 2571: fa_adjustments_mrc_v faadj

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
2575: AND fadp.fiscal_year = h_current_fiscal_yr

Line 4593: FROM FA_ADJUSTMENTS_MRC_V faadj

4589:
4590: begin
4591: SELECT SUM(faadj.adjustment_amount)
4592: INTO h_deprn_amt
4593: FROM FA_ADJUSTMENTS_MRC_V faadj
4594: WHERE
4595: faadj.transaction_header_id = h_th_id_in
4596: AND faadj.source_type_code = 'RETIREMENT'
4597: AND faadj.adjustment_type = 'EXPENSE'

Line 4642: FROM FA_ADJUSTMENTS_MRC_V faadj

4638: else
4639: begin
4640: SELECT SUM(faadj.adjustment_amount)
4641: INTO h_bonus_deprn_amt
4642: FROM FA_ADJUSTMENTS_MRC_V faadj
4643: WHERE
4644: faadj.transaction_header_id = h_th_id_in
4645: AND faadj.source_type_code = 'RETIREMENT'
4646: AND faadj.adjustment_type = 'BONUS EXPENSE'

Line 4693: FROM FA_ADJUSTMENTS_MRC_V faadj

4689: else
4690: begin
4691: SELECT SUM(faadj.adjustment_amount)
4692: INTO h_reval_deprn_amt
4693: FROM FA_ADJUSTMENTS_MRC_V faadj
4694: WHERE
4695: faadj.transaction_header_id = h_th_id_in
4696: AND faadj.source_type_code = 'RETIREMENT'
4697: AND faadj.adjustment_type = 'REVAL EXPENSE'

Line 4741: FROM FA_ADJUSTMENTS_MRC_V faadj

4737: else
4738: begin
4739: SELECT SUM(faadj.adjustment_amount)
4740: INTO h_reval_amort
4741: FROM FA_ADJUSTMENTS_MRC_V faadj
4742: WHERE
4743: faadj.transaction_header_id = h_th_id_in
4744: AND faadj.source_type_code = 'RETIREMENT'
4745: AND faadj.adjustment_type = 'REVAL AMORT'