APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_TRANSACTION_HEADERS

Line 63: from fa_transaction_headers sth

59: select r.retirement_id
60: ,r.units
61: into l_ret_id_in_corp
62: ,l_units_retired
63: from fa_transaction_headers sth
64: ,fa_retirements r
65: ,fa_book_controls bc
66: where sth.transaction_header_id = RET.th_id_in
67: and sth.asset_id = RET.asset_id

Line 95: from fa_transaction_headers sth

91: into l_id_out
92: from fa_distribution_history
93: where retirement_id =
94: (select r.retirement_id
95: from fa_transaction_headers sth
96: ,fa_retirements r
97: where sth.transaction_header_id = RET.th_id_in
98: and sth.asset_id = RET.asset_id
99: and sth.book_type_code = RET.book

Line 184: from fa_transaction_headers

180: -- and source_type_code in ('ADDITION')
181: and adjustment_amount <> 0
182: and transaction_header_id
183: = (select max(transaction_header_id)
184: from fa_transaction_headers
185: where book_type_code = RET.book
186: and asset_id = RET.asset_id
187: and transaction_header_id < RET.th_id_in -- ret thid in TAX
188: )

Line 207: from fa_transaction_headers

203: -- and source_type_code in ('ADDITION')
204: and adjustment_amount <> 0
205: and transaction_header_id
206: = (select max(transaction_header_id)
207: from fa_transaction_headers
208: where book_type_code = RET.book
209: and asset_id = RET.asset_id
210: and transaction_header_id < RET.th_id_in -- ret thid in TAX
211: )

Line 577: from fa_transaction_headers th

573: and adj.period_counter_created = cpd_ctr
574: and adj.adjustment_type = 'COST'
575: and not exists -- check to see if adj.THID is from Corp
576: (select 1
577: from fa_transaction_headers th
578: where th.transaction_header_id = adj.transaction_header_id
579: and th.book_type_code = RET.book
580: and th.asset_id = RET.asset_id
581: )

Line 2593: fa_transaction_headers th

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'
2597: AND th.date_effective between dp1.period_open_date

Line 2799: fa_transaction_headers th

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'
2803: AND th.date_effective between dp.period_open_date

Line 2819: fa_transaction_headers th

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
2823: AND th.transaction_type_code || '' = 'ADDITION'

Line 2848: fa_transaction_headers th

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
2852: AND th.transaction_type_code || '' = 'ADDITION'

Line 2901: fa_transaction_headers th

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
2905: AND th.transaction_type_code || '' = 'REINSTATEMENT'

Line 2929: from fa_transaction_headers trx,

2925: select dp1.period_counter
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