APPS.INVPOPIF dependencies on EGO_IMPORT_OPTION_SETS

Line 308: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;

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
312: l_err_bug VARCHAR2(1000);

Line 1088: ,ego_import_option_sets opt

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
1092: WHEN OTHERS THEN