APPS.FA_GAINLOSS_UND_PKG dependencies on FA_TRANSACTION_HEADERS

Line 120: FROM fa_transaction_headers

116: l_group_thid number(15);
117:
118: CURSOR c_get_group_thid IS
119: SELECT transaction_header_id
120: FROM fa_transaction_headers
121: WHERE member_transaction_header_id = ret.th_id_in
122: AND asset_id = bk.group_asset_id
123: AND book_type_code = ret.book;
124:

Line 636: FA_TRANSACTION_HEADERS TH,

632: SELECT count(*)
633: INTO
634: h_is_prior_period
635: FROM
636: FA_TRANSACTION_HEADERS TH,
637: FA_BOOK_CONTROLS BC,
638: FA_DEPRN_PERIODS DP,
639: FA_DEPRN_PERIODS DP_NOW
640: WHERE

Line 1444: fa_transaction_headers th

1440: dh_new.distribution_id
1441: FROM fa_distribution_history dh_old,
1442: fa_distribution_history dh_new,
1443: fa_book_controls bc,
1444: fa_transaction_headers th
1445: WHERE th.transaction_header_id = h_rethdrout
1446: and th.asset_id = h_asset_id
1447: and th.book_type_code = h_book
1448: and bc.book_type_code = th.book_type_code

Line 3033: FROM fa_transaction_headers

3029: l_group_thid number(15);
3030:
3031: CURSOR c_get_group_thid IS
3032: SELECT transaction_header_id
3033: FROM fa_transaction_headers
3034: WHERE member_transaction_header_id = ret.th_id_in
3035: AND asset_id = bk.group_asset_id
3036: AND book_type_code = ret.book;
3037:

Line 3574: ,FA_TRANSACTION_HEADERS ret_th

3570: ((1/(1-h_cost_frac))-1) * nvl(adj.adjustment_amount, 0),
3571: 0 -- Bug 6666666
3572: FROM FA_DISTRIBUTION_HISTORY dh
3573: ,FA_ASSET_HISTORY ah
3574: ,FA_TRANSACTION_HEADERS ret_th
3575: ,FA_ADJUSTMENTS adj
3576: ,FA_TRANSACTION_HEADERS exp_th
3577: WHERE dh.asset_id = RET.asset_id
3578: AND dh.book_type_code = BK.dis_book

Line 3576: ,FA_TRANSACTION_HEADERS exp_th

3572: FROM FA_DISTRIBUTION_HISTORY dh
3573: ,FA_ASSET_HISTORY ah
3574: ,FA_TRANSACTION_HEADERS ret_th
3575: ,FA_ADJUSTMENTS adj
3576: ,FA_TRANSACTION_HEADERS exp_th
3577: WHERE dh.asset_id = RET.asset_id
3578: AND dh.book_type_code = BK.dis_book
3579: AND dh.date_ineffective is null
3580: AND dh.distribution_id = adj.distribution_id

Line 6242: fa_transaction_headers fth

6238: begin
6239: select transaction_header_id_out,transaction_type_code
6240: into h_th_id_out,h_th_type_code
6241: from fa_retirements rt,
6242: fa_transaction_headers fth
6243: where retirement_id = ret.retirement_id
6244: and rt.transaction_header_id_IN = fth.transaction_header_id
6245: and rt.asset_id = fth.asset_id
6246: and rt.book_type_code = fth.book_type_code;