APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_TRANSACTION_HEADERS

Line 136: from fa_transaction_headers th1,

132: bc.je_adjustment_category),
133: bc.je_adjustment_category
134: ), 'OTHER') je_category_name,
135: th1.date_effective
136: from fa_transaction_headers th1,
137: fa_transaction_headers th2,
138: fa_book_controls bc,
139: fa_deprn_periods dp,
140: fa_trx_references tr,

Line 137: fa_transaction_headers th2,

133: bc.je_adjustment_category
134: ), 'OTHER') je_category_name,
135: th1.date_effective
136: from fa_transaction_headers th1,
137: fa_transaction_headers th2,
138: fa_book_controls bc,
139: fa_deprn_periods dp,
140: fa_trx_references tr,
141: fa_lookups_tl lk1,

Line 676: update fa_transaction_headers th

672: from dual;
673:
674: -- Update table with event_id
675: FORALL l_count IN 1..l_event_id_tbl.count
676: update fa_transaction_headers th
677: set th.event_id = l_event_id_tbl(l_count)
678: where th.rowid = l_src_rowid_tbl(l_count);
679:
680: FORALL l_count IN 1..l_event_id_tbl.count

Line 681: update fa_transaction_headers th

677: set th.event_id = l_event_id_tbl(l_count)
678: where th.rowid = l_src_rowid_tbl(l_count);
679:
680: FORALL l_count IN 1..l_event_id_tbl.count
681: update fa_transaction_headers th
682: set th.event_id = l_event_id_tbl(l_count)
683: where th.rowid = l_dest_rowid_tbl(l_count);
684:
685: l_rows_processed := l_event_id_tbl.count;

Line 2538: from fa_transaction_headers th,

2534: 'UNPLANNED DEPRN', bc.je_depreciation_category,
2535: 'TAX', bc.je_deprn_adjustment_category
2536: ), 'OTHER') je_category_name,
2537: th.date_effective
2538: from fa_transaction_headers th,
2539: fa_asset_history ah,
2540: fa_deprn_periods dp,
2541: gl_sets_of_books glsob,
2542: fa_book_controls bc,

Line 2615: from fa_transaction_headers th,

2611: 'TRANSFER OUT', bc.je_transfer_category,
2612: 'UNIT ADJUSTMENT', bc.je_transfer_category),
2613: 'OTHER') je_category_name,
2614: th.date_effective
2615: from fa_transaction_headers th,
2616: fa_deprn_periods dp,
2617: gl_sets_of_books glsob,
2618: fa_book_controls bc,
2619: fa_lookups_tl lk,

Line 3137: update fa_transaction_headers th

3133: END LOOP;
3134:
3135: -- Update table with event_id
3136: FORALL l_count IN 1..l_event_id_tbl.count
3137: update fa_transaction_headers th
3138: set th.event_id = l_event_id_tbl(l_count)
3139: where th.rowid = l_rowid_tbl(l_count);
3140:
3141: l_rows_processed := l_event_id_tbl.count;

Line 3144: update fa_transaction_headers th

3140:
3141: l_rows_processed := l_event_id_tbl.count;
3142:
3143: FORALL l_count IN 1..l_event_id_tbl.count
3144: update fa_transaction_headers th
3145: set th.event_id = l_event_id_tbl(l_count)
3146: where th.transaction_header_id = l_member_thid_tbl(l_count);
3147:
3148: -- Business Rules for xla_transaction_entities

Line 4534: from fa_transaction_headers th,

4530: to_char(dp.calendar_period_close_date, 'DD-MON-RR')
4531: description,
4532: dp.period_counter period_counter,
4533: th.asset_id asset_id
4534: from fa_transaction_headers th,
4535: fa_book_controls bc,
4536: fa_deprn_periods dp,
4537: gl_period_statuses ps,
4538: fa_lookups_tl lk,

Line 4616: from fa_transaction_headers th,

4612: to_char(dp.calendar_period_close_date, 'DD-MON-RR')
4613: description,
4614: dp.period_counter period_counter,
4615: th.asset_id asset_id
4616: from fa_transaction_headers th,
4617: fa_book_controls bc,
4618: fa_deprn_periods dp,
4619: gl_period_statuses ps,
4620: fa_lookups_tl lk

Line 4654: fa_transaction_headers th

4650: and th.asset_id = adj.asset_id
4651: );
4652:
4653: update /*+ rowid(th) */
4654: fa_transaction_headers th
4655: set th.event_id = nvl(
4656: ( select ev.event_id
4657: from fa_xla_upg_events_gt ev
4658: where ev.transaction_header_id = th.transaction_header_id