[Home] [Help]
202: th.member_transaction_header_id,
203: th.trx_reference_id,
204: th.event_id
205: from fa_books bk,
206: fa_transaction_headers th
207: where bk.asset_id in (l_source_asset_id, l_dest_asset_id)
208: and bk.book_type_code = p_book
209: and bk.adjustment_required_status = 'GADJ'
210: and bk.date_ineffective is null
224: th.member_transaction_header_id,
225: th.trx_reference_id,
226: th.event_id
227: from fa_books bk,
228: fa_transaction_headers th
229: where bk.book_type_code = p_book
230: and bk.adjustment_required_status = 'GADJ'
231: and bk.date_ineffective is null
232: and th.transaction_header_id = bk.transaction_header_id_in
356: , th.last_updated_by
357: , th.last_update_login
358: , th.event_id
359: , tr.transaction_type
360: from fa_transaction_headers th,
361: fa_trx_references tr --Added for bug 537059
362: where th.transaction_header_id = l_trans_rec.member_transaction_header_id
363: and tr.trx_reference_id(+) = th.trx_reference_id; --Added for bug 537059
364:
1342: 'FAPGADJ',
1343: mass_transaction_id,
1344: member_transaction_header_id,
1345: trx_reference_id
1346: from fa_transaction_headers
1347: where transaction_header_id = l_trx_id;
1348:
1349: --Bug6987743: Getting previously transfered reserve
1350: cursor c_get_reserve is
2118: elsif (l_group_reclass_code = 'NONE-GRP') then -- reporting is implied in else
2119:
2120: select transaction_header_id
2121: into l_trans_rec.transaction_header_id
2122: from fa_transaction_headers
2123: where asset_id = l_mem_asset_hdr_rec.asset_id
2124: and book_type_code = l_mem_asset_hdr_rec.book_type_code
2125: and transaction_type_code = 'TRANSFER'
2126: and transaction_header_id > l_mem_trans_rec.transaction_header_id;