APPS.IGS_CA_GEN_001 SQL Statements

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

Line: 16

	SELECT	absolute_val
	FROM 	IGS_CA_DA_INST
	WHERE	DT_ALIAS = cp_dt_alias AND
		sequence_number = cp_sequence_num AND
		CAL_TYPE = cp_cal_type AND
		ci_sequence_number = cp_ci_sequence_num;

Line: 62

		SELECT	ci.alternate_code
		FROM	IGS_CA_INST	ci
		WHERE	ci.CAL_TYPE = cp_cal_type AND
			ci.sequence_number = cp_sequence_number;

Line: 88

SELECT 	closed_ind
FROM	IGS_CA_TYPE
WHERE	CAL_TYPE = p_cal_type;

Line: 125

		SELECT	ci.start_dt,
			ci.end_dt
		FROM	IGS_CA_INST ci
		WHERE	CAL_TYPE	= p_cal_type	AND
			sequence_number	= p_ci_sequence_number;

Line: 170

		SELECT	ci.start_dt
		FROM	IGS_CA_INST	ci
		WHERE	ci.CAL_TYPE 	= p_cal_type 	AND
			sequence_number = p_sequence_number;

Line: 214

		SELECT	sgcc.census_dt_alias
		FROM	IGS_GE_S_GEN_CAL_CON 	sgcc
		WHERE	sgcc.s_control_num = 1;

Line: 220

		SELECT	ci.start_dt,
			ci.end_dt
		FROM	IGS_CA_INST	ci
		WHERE	ci.CAL_TYPE = cp_source_cal_type AND
			ci.sequence_number = cp_source_ci_sequence_number;

Line: 229

		SELECT	daiv.alias_val
		FROM	IGS_CA_DA_INST_V	daiv
		WHERE	daiv.CAL_TYPE = cp_related_cal_type AND
			daiv.ci_sequence_number = cp_related_ci_sequence_number AND
			daiv.DT_ALIAS = cp_census_dt_alias;

Line: 318

		SELECT	sup_ci_sequence_number
		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;

Line: 355

		SELECT S_CAL_CAT
		FROM IGS_CA_TYPE
		WHERE	CAL_TYPE = p_cal_type;