APPS.IGS_CA_VAL_CIR SQL Statements

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

Line: 41

  		   SELECT s_cal_cat
  		   FROM	 igs_ca_type	cat
  		   WHERE	 cat.cal_type = p_cal_type;

Line: 92

   	   SELECT *
         FROM	 igs_ca_inst_rel
   	   WHERE  sub_cal_type = p_sub_cal_type
   	   AND    sub_ci_sequence_number = p_sub_ci_sequence_number
   	   AND    (sup_cal_type <> p_sup_cal_type)
   	   AND    (sup_ci_sequence_number <> p_sup_ci_sequence_number);

Line: 100

   	   SELECT *
         FROM	 igs_ca_inst_rel
   	   WHERE  sup_cal_type = p_sup_cal_type
   	   AND    sup_ci_sequence_number = p_sup_ci_sequence_number
   	   AND    (sub_cal_type <> p_sub_cal_type)
   	   AND    (sub_ci_sequence_number <> p_sub_ci_sequence_number);

Line: 109

   		SELECT *
   		FROM   igs_ca_inst
   		WHERE	 cal_type = cp_cal_type
   		AND    sequence_number = cp_cal_sequence_number ;

Line: 115

   		SELECT *
   		FROM   igs_ca_stat
   		WHERE  cal_status = cp_cal_status;

Line: 129

   		SELECT  *
   		FROM	  igs_ca_inst_rel
   		WHERE	  sub_cal_type = cp_sup_cal_type
   		AND	  sub_ci_sequence_number = cp_sup_ci_sequence_number;

Line: 180

  	SELECT *
  	FROM	 igs_ca_inst_rel
  	WHERE	 sup_cal_type = cp_sub_cal_type
	AND	 sup_ci_sequence_number = cp_sub_ci_sequence_number; --simran perf --this was missing.