APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_TRANSACTION_HEADERS

Line 142: from fa_transaction_headers th1,

138: bc.je_adjustment_category),
139: bc.je_adjustment_category
140: ), 'OTHER') je_category_name,
141: th1.date_effective
142: from fa_transaction_headers th1,
143: fa_transaction_headers th2,
144: fa_book_controls bc,
145: fa_deprn_periods dp,
146: fa_trx_references tr,

Line 143: fa_transaction_headers th2,

139: bc.je_adjustment_category
140: ), 'OTHER') je_category_name,
141: th1.date_effective
142: from fa_transaction_headers th1,
143: fa_transaction_headers th2,
144: fa_book_controls bc,
145: fa_deprn_periods dp,
146: fa_trx_references tr,
147: fa_lookups_tl lk1,

Line 722: update fa_transaction_headers th

718: set trx.event_id = l_event_id_tbl(l_count)
719: where trx.rowid = l_tr_rowid_tbl(l_count);
720:
721: FORALL l_count IN 1..l_event_id_tbl.count
722: update fa_transaction_headers th
723: set th.event_id = l_event_id_tbl(l_count)
724: where th.rowid = l_src_rowid_tbl(l_count);
725:
726: FORALL l_count IN 1..l_event_id_tbl.count

Line 727: update fa_transaction_headers th

723: set th.event_id = l_event_id_tbl(l_count)
724: where th.rowid = l_src_rowid_tbl(l_count);
725:
726: FORALL l_count IN 1..l_event_id_tbl.count
727: update fa_transaction_headers th
728: set th.event_id = l_event_id_tbl(l_count)
729: where th.rowid = l_dest_rowid_tbl(l_count);
730:
731: l_rows_processed := l_event_id_tbl.count;

Line 2604: from fa_transaction_headers th,

2600: 'UNPLANNED DEPRN', bc.je_depreciation_category,
2601: 'TAX', bc.je_deprn_adjustment_category
2602: ), 'OTHER') je_category_name,
2603: th.date_effective
2604: from fa_transaction_headers th,
2605: fa_asset_history ah,
2606: fa_deprn_periods dp,
2607: gl_sets_of_books glsob,
2608: fa_book_controls bc,

Line 2681: from fa_transaction_headers th,

2677: 'TRANSFER OUT', bc.je_transfer_category,
2678: 'UNIT ADJUSTMENT', bc.je_transfer_category),
2679: 'OTHER') je_category_name,
2680: th.date_effective
2681: from fa_transaction_headers th,
2682: fa_deprn_periods dp,
2683: gl_sets_of_books glsob,
2684: fa_book_controls bc,
2685: fa_lookups_tl lk,

Line 3231: update fa_transaction_headers th

3227: END LOOP;
3228:
3229: -- Update table with event_id
3230: FORALL l_count IN 1..l_event_id_tbl.count
3231: update fa_transaction_headers th
3232: set th.event_id = l_event_id_tbl(l_count)
3233: where th.rowid = l_rowid_tbl(l_count);
3234:
3235: l_rows_processed := l_event_id_tbl.count;

Line 3238: update fa_transaction_headers th

3234:
3235: l_rows_processed := l_event_id_tbl.count;
3236:
3237: FORALL l_count IN 1..l_event_id_tbl.count
3238: update fa_transaction_headers th
3239: set th.event_id = l_event_id_tbl(l_count)
3240: where th.transaction_header_id = l_member_thid_tbl(l_count);
3241:
3242: -- Business Rules for xla_transaction_entities

Line 4650: from fa_transaction_headers th,

4646: and adj.asset_id = th.asset_id
4647: and adj.transaction_header_id = th.transaction_header_id
4648: and nvl(adj.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
4649: bc.gl_posting_allowed_flag gl_posting_allowed_flag
4650: from fa_transaction_headers th,
4651: fa_book_controls bc,
4652: fa_deprn_periods dp,
4653: gl_period_statuses ps,
4654: fa_lookups_tl lk,

Line 4751: from fa_transaction_headers th,

4747: and adj.asset_id = th.asset_id
4748: and adj.transaction_header_id = th.transaction_header_id
4749: and nvl(adj.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
4750: bc.gl_posting_allowed_flag gl_posting_allowed_flag
4751: from fa_transaction_headers th,
4752: fa_book_controls bc,
4753: fa_deprn_periods dp,
4754: gl_period_statuses ps,
4755: fa_lookups_tl lk,

Line 4792: fa_transaction_headers th

4788: and th.asset_id = adj.asset_id
4789: ) or th.event_id = -3); -- Bug 9055709
4790:
4791: update /*+ rowid(th) */
4792: fa_transaction_headers th
4793: set th.event_id = nvl(
4794: ( select ev.event_id
4795: from fa_xla_upg_events_gt ev
4796: where ev.transaction_header_id = th.transaction_header_id