APPS.IGS_FI_WAV_DTLS_WF SQL Statements

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

Line: 44

      SELECT description
      FROM IGS_CA_INST_ALL
      WHERE cal_type = c_cal_load_cal_type
      AND sequence_number = c_n_load_ci_seq_number;

Line: 50

      SELECT person_number, full_name
      FROM IGS_PE_PERSON_BASE_V
      WHERE person_id = c_n_person_id;

Line: 55

      SELECT api_person_id, person_id_type
      FROM igs_pe_person_id_type_v
      WHERE pe_person_id = c_n_person_id;

Line: 60

      SELECT  igs_fi_wav_wf_trans_fa_s.NEXTVAL
      FROM sys.dual;

Line: 162

        l_parameter_list.DELETE;

Line: 182

    SELECT person_number, full_name
    FROM IGS_PE_PERSON_BASE_V
    WHERE person_id = c_n_person_id;

Line: 187

    SELECT  igs_fi_wav_wf_stud_s.NEXTVAL
    FROM sys.dual;

Line: 235

      l_parameter_list.DELETE;