APPS.IGS_AD_OFFRESP_STATUS_WF SQL Statements

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

Line: 22

      SELECT igs_ad_offresp_stat_wf_s.NEXTVAL
      FROM     SYS.dual;

Line: 26

      SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
      FROM dual;

Line: 83

        l_parameter_list.delete;

Line: 120

    SELECT person_number, full_name
    FROM igs_pe_person_base_v
    WHERE person_id = l_person_id;

Line: 125

    SELECT user_name
    FROM fnd_user
    WHERE user_id = fnd_global.user_id;

Line: 176

    SELECT person_number, full_name
    FROM igs_pe_person_base_v
    WHERE person_id = p_person_id;

Line: 182

    SELECT alternate_code
    FROM igs_ca_inst
    WHERE cal_type = p_cal_type
    AND sequence_number = p_sequence_number;

Line: 191

    SELECT admprd.single_response_flag
    FROM igs_ad_prd_ad_prc_ca admprd,
         igs_ad_appl_all appl,
         igs_ad_ps_appl_inst_all aplinst
    WHERE appl.person_id = p_person_id
          AND appl.admission_appl_number = p_admission_appl_number
          AND appl.person_id = aplinst.person_id
          AND appl.admission_appl_number = aplinst.admission_appl_number
          AND admprd.adm_cal_type = NVL(aplinst.adm_cal_type,appl.adm_cal_type)
          AND admprd.adm_ci_sequence_number = NVL(aplinst.adm_ci_sequence_number,appl.adm_ci_sequence_number)
          AND admprd.admission_cat = p_admission_cat
          AND admprd.s_admission_process_type = p_s_admission_process_type;

Line: 205

    SELECT user_name
    FROM fnd_user
    WHERE user_id = fnd_global.user_id;