APPS.IGS_AD_WF_P2A SQL Statements

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

Line: 45

    igs_ge_msg_stack.delete_msg(l_msg_idx_start);

Line: 74

      SELECT  admission_cat,s_admission_process_type
      FROM  igs_ad_ss_appl_typ
      WHERE admission_application_type = cp_app_type;

Line: 79

      SELECT IGS_SS_ADM_APPL_S.NEXTVAL
      FROM sys.dual;

Line: 295

       SELECT application_fee_amount,admission_application_type
       FROM igs_ad_ss_appl_typ
       WHERE admission_application_type = cp_app_type;

Line: 300

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

Line: 304

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

Line: 785

      SELECT code_id
      FROM igs_ad_code_classes
      WHERE upper(system_status) = cp_source
            and class = 'SYS_APPL_SOURCE' and system_default = 'Y'
	    AND CLASS_TYPE_CODE='ADM_CODE_CLASSES';

Line: 860

      SELECT  admission_cat,s_admission_process_type
      FROM  igs_ad_ss_appl_typ
      WHERE admission_application_type = cp_app_type;

Line: 867

      SELECT s_admission_process_type
      FROM IGS_AD_PRD_AD_PRC_CA
      WHERE adm_cal_type = p_adm_cal_type AND
            adm_ci_sequence_number = p_adm_cal_seq AND
            admission_cat = p_admission_cat AND
            s_admission_process_type = p_s_admission_process_type;