DBA Data[Home] [Help]

APPS.IGI_IAC_EXTRACT_PKG dependencies on XLA_EVENTS_GT

Line 33: select * from xla_events_gt

29: l_procedure_name varchar2(80) := 'extract_revaluations';
30: l_path_name varchar2(2000);
31:
32: cursor all_events is
33: select * from xla_events_gt
34: where entity_code = 'TRANSACTIONS'
35: and event_type_code = 'INFLATION_REVALUATION';
36:
37: cursor fa_header (p_event_id number,

Line 281: select * from xla_events_gt

277: l_procedure_name varchar2(80) := 'extract_transactions';
278: l_path_name varchar2(2000);
279:
280: cursor all_events is
281: select * from xla_events_gt
282: where entity_code in ('TRANSACTIONS','DEPRECIATION')
283: and event_type_code in ('ADDITIONS','ADJUSTMENTS','TRANSFERS',
284: 'CATEGORY_RECLASS', 'RETIREMENTS','REINSTATEMENTS','DEPRECIATION');
285: cursor fa_igi_lines (p_event_id number,p_book_type_code varchar2) is

Line 639: igi_lookups lkp_adj, igi_lookups lkp_trn, xla_events_gt ctlgd,

635: decode(adj.adjustment_type,'EXPENSE',code_combination_id,null),
636: decode(adj.adjustment_type,'NBV RETIRED',code_combination_id,null),
637: sob.currency_code
638: from igi_iac_adjustments adj, igi_iac_transaction_headers th,
639: igi_lookups lkp_adj, igi_lookups lkp_trn, xla_events_gt ctlgd,
640: gl_sets_of_books sob
641: where adj.adjustment_id = th.adjustment_id
642: and adj.event_id = th.event_id
643: and lkp_adj.lookup_type = 'IGI_IAC_ADJUSTMENT_TYPES'