APPS.INVPOPIF dependencies on EGO_IMPORT_OPTION_SETS

Line 276: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;

272: l_industry VARCHAR2(1);
273: l_records NUMBER(10);
274: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
275: l_source_system_id EGO_IMPORT_BATCHES_B.source_system_id%TYPE;
276: l_import_xref_only EGO_IMPORT_OPTION_SETS.import_xref_only%TYPE;
277: l_items_bulk_rec_cnt NUMBER;
278:
279: BEGIN
280: /*Added for bug 6372595*/

Line 915: ,ego_import_option_sets opt

911: BEGIN
912: SELECT batch.source_system_id, NVL(opt.import_xref_only,'N')
913: INTO l_source_system_id, l_import_xref_only
914: FROM ego_import_batches_b batch
915: ,ego_import_option_sets opt
916: WHERE batch.batch_id = xset_id
917: AND batch.batch_id = opt.batch_id;
918: EXCEPTION
919: WHEN OTHERS THEN