APPS.INVPOPIF dependencies on EGO_IMPORT_BATCHES_B

Line 307: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;

303: l_status VARCHAR2(1);
304: l_industry VARCHAR2(1);
305: l_records NUMBER(10);
306: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
307: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
308: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
309: l_items_bulk_rec_cnt NUMBER;
310:
311: -- Bug 9092888 - changes

Line 1087: FROM ego_import_batches_b batch

1083: --Start : 5513065 Including xref import into same transaction context of item+rev
1084: BEGIN
1085: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N')
1086: INTO l_source_system_id, l_import_xref_only
1087: FROM ego_import_batches_b batch
1088: ,ego_import_option_sets opt
1089: WHERE batch.batch_id = xset_id
1090: AND batch.batch_id = opt.batch_id;
1091: EXCEPTION