APPS.EGO_IMPORT_BATCHES_PKG dependencies on DUAL

Line 686: SELECT MTL_SYSTEM_ITEMS_INTF_SETS_S.nextval INTO l_batch_id FROM dual;

682: l_assignee_id := fnd_global.user_id;
683: END IF;
684:
685: -- 2. Generate Batch Option Set ID & Batch Id.
686: SELECT MTL_SYSTEM_ITEMS_INTF_SETS_S.nextval INTO l_batch_id FROM dual;
687: select EGO_IMPORT_OPTION_SETS_S.nextval INTO l_option_set_id FROM dual;
688:
689: -------------------------------------------------------
690: --- Initializing Input Params ---

Line 687: select EGO_IMPORT_OPTION_SETS_S.nextval INTO l_option_set_id FROM dual;

683: END IF;
684:
685: -- 2. Generate Batch Option Set ID & Batch Id.
686: SELECT MTL_SYSTEM_ITEMS_INTF_SETS_S.nextval INTO l_batch_id FROM dual;
687: select EGO_IMPORT_OPTION_SETS_S.nextval INTO l_option_set_id FROM dual;
688:
689: -------------------------------------------------------
690: --- Initializing Input Params ---
691: -------------------------------------------------------

Line 761: FROM DUAL;

757: l_def_match_rule_rn_app_id,
758: l_def_match_rule_rn_code,
759: l_nir_option,
760: l_enabled_for_data_pool
761: FROM DUAL;
762:
763: IF l_source_system_id = 7 THEN
764: --should ignore l_apply_def_match_rule_all, l_match_on_data_load, l_confirm_single_match, set them to null.
765: l_match_on_data_load := l_tmp_ssm_options_rec.MATCH_ON_DATA_LOAD;