APPS.IGS_CA_COMPUTE_DA_VAL_PKG SQL Statements

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

Line: 35

  SELECT date_alias
  FROM   IGS_CA_DA_CONFIGS
  WHERE  sys_date_type = cp_sys_date;

Line: 69

    SELECT date_alias
    FROM   IGS_CA_DA_OVD_VALS
    WHERE  sys_date_type       = cp_sys_date_type AND
           element_code        = cp_elt_level AND
           element_code_value  = cp_elt_code;

Line: 113

    SELECT count(*)
    FROM   IGS_CA_DA_INST
    WHERE  dt_alias           = cp_dt_alias AND
           cal_type           = cp_cal_type AND
           ci_sequence_number = cp_seq_num;

Line: 122

    SELECT alias_val
    FROM   IGS_CA_DA_INST_V
    WHERE  dt_alias           = cp_dt_alias AND
           cal_type           = cp_cal_type AND
           ci_sequence_number = cp_seq_num;

Line: 358

  SELECT offset_dt_alias,offset_dai_sequence_number,offset_cal_type,offset_ci_sequence_number,ofst_override
  FROM   IGS_CA_DA_INST_OFST
  WHERE  dt_alias            = cp_dt_alias AND
         dai_sequence_number = cp_da_seq_num AND
         cal_type            = cp_cal_type AND
         ci_sequence_number  = cp_seq_num;

Line: 406

SELECT offset_dt_alias,offset_dai_sequence_number,offset_cal_type,offset_ci_sequence_number,day_offset,week_offset,month_offset,year_offset,ofst_override
FROM   IGS_CA_DA_INST_OFST
WHERE  dt_alias            = cp_dt_alias AND
       dai_sequence_number = cp_da_seq_num AND
       cal_type            = cp_cal_type AND
       ci_sequence_number  = cp_seq_num;

Line: 416

SELECT offset_dt_alias,day_offset,week_offset,month_offset,year_offset
FROM   IGS_CA_DA_OFST
WHERE  dt_alias = cp_dt_alias;

Line: 499

  SELECT sys_date_type
  FROM   IGS_CA_DA_CONFIGS
  WHERE  date_alias = cp_dt_alias;

Line: 505

  SELECT count(*)
  FROM IGS_CA_DA_CONFIGS
  WHERE  date_alias = cp_dt_alias;