APPS.IGS_AD_GEN_016 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

    SELECT lookup_code, enabled_flag, meaning
    FROM   fnd_lookup_values
    WHERE  lookup_type = lv_lookup_type
    AND    view_application_id = ln_appl_id
    AND    language = l_language
    AND    security_group_id = l_security_group_id;

Line: 42

      SELECT USERENV('LANG') INTO l_language FROM DUAL;

Line: 137

    SELECT lookup_code, enabled_flag, meaning
    FROM   fnd_lookup_values
    WHERE  lookup_type = lv_lookup_type
    AND    view_application_id = ln_appl_id
    AND    language = l_language
    AND    security_group_id = l_security_group_id;

Line: 148

      SELECT USERENV('LANG') INTO l_language FROM DUAL;

Line: 183

    SELECT application_id
    FROM   fnd_application
    WHERE  application_short_name = lv_appl_short_name;

Line: 191

    SELECT NVL(type,'ERROR') type
    FROM   fnd_new_messages
    WHERE  message_name = lv_message_name
    AND    application_id = ln_appl_id
    AND    language_code = l_language;

Line: 201

      SELECT USERENV('LANG') INTO l_language FROM DUAL;

Line: 324

    SELECT category_name, include_ind, detail_level_ind, discrepancy_rule_cd
    FROM   igs_ad_source_cat_all
    WHERE  source_type_id = ln_source_type_id;

Line: 561

    SELECT code_id, name, system_status, closed_ind, system_default
    FROM   igs_ad_code_classes
    WHERE  class = lv_class
    AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line: 764

    SELECT admission_application_type, admission_cat, s_admission_process_type
    FROM   igs_ad_ss_appl_typ;

Line: 885

    SELECT s_admission_step_type, mandatory_step_ind, step_type_restriction_num
    FROM   igs_ad_prcs_cat_step_all
    WHERE  admission_cat = lv_admission_cat
    AND    s_admission_process_type = lv_s_admission_process_type
    AND    step_group_type <> lv_step_group_type_excl;

Line: 1023

      igs_ge_msg_stack.delete_msg(l_msg_idx_start);

Line: 1115

      IGS_GE_MSG_STACK.DELETE_MSG(l_msg_index);