[Home] [Help]
196: th.member_transaction_header_id,
197: th.trx_reference_id,
198: th.event_id
199: from fa_books bk,
200: fa_transaction_headers th
201: where bk.asset_id in (l_source_asset_id, l_dest_asset_id)
202: and bk.book_type_code = p_book
203: and bk.adjustment_required_status = 'GADJ'
204: and bk.date_ineffective is null
218: th.member_transaction_header_id,
219: th.trx_reference_id,
220: th.event_id
221: from fa_books bk,
222: fa_transaction_headers th
223: where bk.book_type_code = p_book
224: and bk.adjustment_required_status = 'GADJ'
225: and bk.date_ineffective is null
226: and th.transaction_header_id = bk.transaction_header_id_in
364: , th.last_updated_by
365: , th.last_update_login
366: , th.event_id
367: , tr.transaction_type
368: from fa_transaction_headers th,
369: fa_trx_references tr --Added for bug 537059
370: where th.transaction_header_id = l_trans_rec.member_transaction_header_id
371: and tr.trx_reference_id(+) = th.trx_reference_id; --Added for bug 537059
372:
1533: 'FAPGADJ',
1534: mass_transaction_id,
1535: member_transaction_header_id,
1536: trx_reference_id
1537: from fa_transaction_headers
1538: where transaction_header_id = l_trx_id;
1539:
1540: --Bug6987743: Getting previously transfered reserve
1541: cursor c_get_reserve is
2396: update fa_mc_adjustments
2397: set track_member_flag = null
2398: where transaction_header_id in
2399: (select transaction_header_id
2400: from fa_transaction_headers th_in
2401: where th_in.asset_id = l_mem_asset_hdr_rec.asset_id
2402: and th_in.book_type_code = l_mem_asset_hdr_rec.book_type_code
2403: and th_in.transaction_type_code = 'TRANSFER'
2404: and th_in.transaction_header_id > l_mem_trans_rec.transaction_header_id);