APPS.IGS_EN_GEN_014 SQL Statements

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

Line: 304

       SELECT  DISTINCT  ci.cal_type,
                         ci.sequence_number,
                         ci.alternate_code,
                         ci.start_dt,
                         ci.end_dt,
                         ci.description
       FROM    igs_ca_type ct,
               igs_ca_inst ci,
               igs_ca_stat cs,
               igs_ca_inst_rel cir
      WHERE    cs.s_cal_status = cst_active
      AND      ci.cal_status = cs.cal_status
      AND      ct.s_cal_cat = cst_load
      AND      ci.cal_type = ct.cal_type
      AND      CIR.SUB_CAL_TYPE = CI.CAL_TYPE
      AND      cir.sub_ci_sequence_number =ci.sequence_number
      AND      cir.sup_cal_type = cp_cal_type
      AND      p_effective_dt Between ci.start_dt AND ci.end_dt
      ORDER BY ci.start_dt;

Line: 373

       SELECT   DISTINCT ci.cal_type,
                         ci.sequence_number,
                         ci.alternate_code,
                         ci.start_dt,
                         ci.end_dt,
                         ci.description
       FROM    igs_ca_type ct,
               igs_ca_inst ci,
               igs_ca_stat cs,
               igs_ca_inst_rel cir
       WHERE    cs.s_cal_status = cst_active
       AND      ci.cal_status = cs.cal_status
       AND      ct.s_cal_cat = cst_load
       AND      ci.cal_type = ct.cal_type
       AND      CIR.SUB_CAL_TYPE = CI.CAL_TYPE
       AND      cir.sub_ci_sequence_number =ci.sequence_number
       AND      cir.sup_cal_type = cp_cal_type
       AND      ci.start_dt > cp_cur_cal_erly_st_dt
       ORDER BY ci.start_dt ;

Line: 477

         SELECT   ci.cal_type,
                  ci.sequence_number,
                  ci.alternate_code,
                  ci.start_dt,
                  ci.end_dt,
                  ci.description
         FROM    igs_ca_inst ci
         WHERE   ci.cal_type = cp_caltype
         AND     ci.sequence_number = cp_cal_seqno;

Line: 555

    ckasu      22-JUL-2004    changed the code in if case by removing DELETE Function
  --------------------------------------------------------------------*/

    l_load_cal_table_info load_cal_table_type;

Line: 601

          SELECT  secc.load_effect_dt_alias
          FROM    igs_en_cal_conf secc
          WHERE   secc.s_control_num = 1;

Line: 696

          SELECT   daiv.alias_val
          FROM     igs_ca_da_inst_v daiv
          WHERE    daiv.cal_type = cp_cal_type
          AND      daiv.ci_sequence_number = cp_ci_sequence_number
          AND      daiv.dt_alias = cp_load_effect_dt_alias;