APPS.IGI_IAC_EXTRACT_PKG dependencies on GL_SETS_OF_BOOKS

Line 97: igi_lookups lkp_adj, igi_lookups lkp_trn, gl_sets_of_books sob

93: decode(adj.adjustment_type,'EXPENSE',code_combination_id,null) EXPENSE,
94: decode(adj.adjustment_type,'NBV RETIRED',code_combination_id,null) NBV_RETIRED,
95: sob.currency_code
96: from igi_iac_adjustments adj, igi_iac_transaction_headers th,
97: igi_lookups lkp_adj, igi_lookups lkp_trn, gl_sets_of_books sob
98: where adj.adjustment_id = th.adjustment_id
99: and adj.event_id = th.event_id
100: and lkp_adj.lookup_type = 'IGI_IAC_ADJUSTMENT_TYPES'
101: and lkp_trn.lookup_type = 'IGI_IAC_TRANSACTION_TYPES'

Line 326: igi_lookups lkp_adj, igi_lookups lkp_trn, gl_sets_of_books sob

322: decode(adj.adjustment_type,'EXPENSE',code_combination_id,null) EXPENSE,
323: decode(adj.adjustment_type,'NBV RETIRED',code_combination_id,null) NBV_RETIRED,
324: sob.currency_code
325: from igi_iac_adjustments adj, igi_iac_transaction_headers th,
326: igi_lookups lkp_adj, igi_lookups lkp_trn, gl_sets_of_books sob
327: where adj.adjustment_id = th.adjustment_id
328: and adj.event_id = th.event_id
329: and lkp_adj.lookup_type = 'IGI_IAC_ADJUSTMENT_TYPES'
330: and lkp_trn.lookup_type = 'IGI_IAC_TRANSACTION_TYPES'

Line 640: gl_sets_of_books sob

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'
644: and lkp_trn.lookup_type = 'IGI_IAC_TRANSACTION_TYPES'