APPS.IGS_CA_GEN_002 SQL Statements

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

Line: 98

			SELECT	TRUNC(dai.absolute_val)
			FROM	IGS_CA_DA_INST	dai,
				IGS_CA_INST		ci,
				IGS_CA_TYPE		ct,
				IGS_CA_STAT		cs
			WHERE	dai.CAL_TYPE		= ci.CAL_TYPE AND
				dai.ci_sequence_number  = ci.sequence_number AND
				ci.CAL_TYPE		= ct.CAL_TYPE	AND
				ct.S_CAL_CAT		= cst_holiday	AND
				cs.CAL_STATUS		= ci.CAL_STATUS	AND
				cs.s_cal_status		= cst_active
			ORDER BY dai.absolute_val ASC;

Line: 112

			SELECT	TRUNC(dai.absolute_val)
			FROM	IGS_CA_DA_INST	dai,
				IGS_CA_INST		ci,
				IGS_CA_TYPE		ct,
				IGS_CA_STAT		cs
			WHERE	dai.CAL_TYPE		= ci.CAL_TYPE AND
				dai.ci_sequence_number  = ci.sequence_number AND
				ci.CAL_TYPE		= ct.CAL_TYPE	AND
				ct.S_CAL_CAT		= cst_holiday	AND
				cs.CAL_STATUS		= ci.CAL_STATUS	AND
				cs.s_cal_status		= cst_active
			ORDER BY dai.absolute_val DESC;

Line: 127

			SELECT	'x'
			FROM	IGS_CA_TYPE ct
			WHERE	ct.S_CAL_CAT		= cst_holiday	AND
			EXISTS	(SELECT	'x'
				 FROM	IGS_CA_INST ci,
					IGS_CA_STAT cs
				WHERE	ci.CAL_TYPE = ct.CAL_TYPE	AND
					ci.CAL_STATUS = cs.CAL_STATUS	AND
					cs.s_cal_status = cst_active	AND
					EXISTS 	(SELECT	'x'
					 	 FROM	IGS_CA_DA_INST dai
						 WHERE	dai.CAL_TYPE = ct.CAL_TYPE	AND
							TRUNC(dai.absolute_val) = cp_alias_val));

Line: 180

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 188

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 252

			SELECT	TRUNC(dai2.absolute_val)
			FROM	IGS_CA_DA_INST		dai1,
				IGS_CA_DA_INST		dai2,
				IGS_CA_DA_INST_PAIR	daip,
				IGS_CA_INST		ci,
				IGS_CA_TYPE		ct,
				IGS_CA_STAT		cs
			WHERE	ci.CAL_TYPE		= ct.CAL_TYPE				AND
				ct.S_CAL_CAT		= cst_holiday				AND
				cs.CAL_STATUS		= ci.CAL_STATUS				AND
				cs.s_cal_status		= cst_active				AND
				dai1.CAL_TYPE		= ci.CAL_TYPE				AND
				dai1.DT_ALIAS		= daip.DT_ALIAS				AND
				dai1.sequence_number	= daip.dai_sequence_number		AND
				dai1.CAL_TYPE		= daip.CAL_TYPE				AND
				dai1.ci_sequence_number = daip.ci_sequence_number		AND
				dai2.DT_ALIAS		= daip.related_dt_alias			AND
				dai2.sequence_number	= daip.related_dai_sequence_number	AND
				dai2.CAL_TYPE		= daip.related_cal_type			AND
				dai2.ci_sequence_number = daip.related_ci_sequence_number
			ORDER BY dai2.absolute_val DESC;

Line: 275

			SELECT	TRUNC(dai1.absolute_val)
			FROM	IGS_CA_DA_INST		dai1,
				IGS_CA_DA_INST		dai2,
				IGS_CA_DA_INST_PAIR	daip,
				IGS_CA_INST		ci,
				IGS_CA_TYPE		ct,
				IGS_CA_STAT		cs
			WHERE	ci.CAL_TYPE		= ct.CAL_TYPE				AND
				ct.S_CAL_CAT		= cst_holiday				AND
				cs.CAL_STATUS		= ci.CAL_STATUS				AND
				cs.s_cal_status		= cst_active				AND
				dai1.CAL_TYPE		= ci.CAL_TYPE				AND
				dai1.DT_ALIAS		= daip.DT_ALIAS				AND
				dai1.sequence_number	= daip.dai_sequence_number		AND
				dai1.CAL_TYPE		= daip.CAL_TYPE				AND
				dai1.ci_sequence_number = daip.ci_sequence_number		AND
				dai2.DT_ALIAS		= daip.related_dt_alias			AND
				dai2.sequence_number	= daip.related_dai_sequence_number	AND
				dai2.CAL_TYPE		= daip.related_cal_type			AND
				dai2.ci_sequence_number = daip.related_ci_sequence_number
			ORDER BY dai1.absolute_val ASC;

Line: 299

			SELECT	'x'
			FROM	IGS_CA_TYPE ct
			WHERE	ct.S_CAL_CAT = cst_holiday	AND
			EXISTS	(SELECT	'x'
				 FROM	IGS_CA_INST ci,
					IGS_CA_STAT cs
				 WHERE	ci.CAL_TYPE	= ct.CAL_TYPE	AND
					ci.CAL_STATUS	= cs.CAL_STATUS	AND
					cs.s_cal_status	= cst_active	AND
					EXISTS	(SELECT	'x'
					FROM	IGS_CA_DA_INST dai1,
						IGS_CA_DA_INST dai2,
						IGS_CA_DA_INST_PAIR daip
					WHERE	dai1.CAL_TYPE	= ct.CAL_TYPE	AND
						dai1.DT_ALIAS	 = daip.DT_ALIAS    AND
 						dai1.sequence_number	= daip.dai_sequence_number  AND
 						dai1.CAL_TYPE	= daip.CAL_TYPE    AND
 						dai1.ci_sequence_number	= daip.ci_sequence_number  AND
						dai2.DT_ALIAS	= daip.related_dt_alias   AND
 						dai2.sequence_number	= daip.related_dai_sequence_number AND
	 					dai2.CAL_TYPE	= daip.related_cal_type   AND
						dai2.ci_sequence_number	= daip.related_ci_sequence_number AND
						 cp_alias_val BETWEEN TRUNC(dai1.absolute_val) AND
							TRUNC(dai2.absolute_val)));

Line: 361

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 369

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 417

			SELECT	daoc.S_DT_OFFSET_CONSTRAINT_TYPE,
				daoc.constraint_condition,
				daoc.constraint_resolution
			FROM	IGS_CA_DA_INST_OFCNT	 daoc
			WHERE	daoc.DT_ALIAS			= p_dt_alias	AND
				daoc.dai_sequence_number		= p_sequence_number	AND
				daoc.CAL_TYPE			= p_cal_type	AND
				daoc.ci_sequence_number 		= p_ci_sequence_number;

Line: 534

		-- 4. Use a loop to select each existiong constraint record.
		--    and check the constraint against the date and if a clash exists,
		--    attempt to resolve it.
		calpl_constraint_resolve (
					v_constraint_count,
					v_mod_count,
					v_alias_val,
					v_message_name);

Line: 619

			SELECT	TRUNC(max(dai.absolute_val)), TRUNC(min(dai.absolute_val))
			FROM	IGS_CA_DA_INST	dai,
				IGS_CA_INST		ci,
				IGS_CA_TYPE		ct,
				IGS_CA_STAT		cs
			WHERE	ci.CAL_TYPE		= ct.CAL_TYPE	AND
				ct.S_CAL_CAT		= cst_holiday	AND
				cs.s_cal_status		= ci.CAL_STATUS	AND
				cs.s_cal_status		= cst_active	AND
				dai.CAL_TYPE		= ci.CAL_TYPE;

Line: 631

			SELECT	'x'
			FROM	IGS_CA_TYPE ct
			WHERE	ct.S_CAL_CAT		= cst_holiday	AND
			EXISTS	(SELECT	'x'
				 FROM	IGS_CA_INST ci,
					IGS_CA_STAT cs
				WHERE	ci.CAL_TYPE	= ct.CAL_TYPE	AND
					ci.CAL_STATUS	= cs.CAL_STATUS	AND
					cs.s_cal_status	= cst_active	AND
					EXISTS 	(SELECT	'x'
					 	 FROM	IGS_CA_DA_INST dai
						 WHERE	dai.CAL_TYPE = ct.CAL_TYPE	AND
							TRUNC(dai.absolute_val)= cp_alias_val));

Line: 678

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 686

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 740

			SELECT	TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
			FROM	IGS_CA_DA_INST		dai1,
				IGS_CA_DA_INST		dai2,
				IGS_CA_DA_INST_PAIR	daip,
				IGS_CA_INST		ci,
				IGS_CA_TYPE		ct,
				IGS_CA_STAT		cs
			WHERE	ci.CAL_TYPE		= ct.CAL_TYPE				AND
				ct.S_CAL_CAT		= cst_holiday				AND
				cs.s_cal_status		= ci.CAL_STATUS				AND
				cs.s_cal_status		= cst_active				AND
				dai1.CAL_TYPE		= ci.CAL_TYPE				AND
				dai1.DT_ALIAS		= daip.DT_ALIAS				AND
				dai1.sequence_number	= daip.dai_sequence_number		AND
				dai1.CAL_TYPE		= daip.CAL_TYPE				AND
				dai1.ci_sequence_number = daip.ci_sequence_number		AND
				dai2.DT_ALIAS		= daip.related_dt_alias			AND
				dai2.sequence_number	= daip.related_dai_sequence_number	AND
				dai2.CAL_TYPE		= daip.related_cal_type			AND
				dai2.ci_sequence_number = daip.related_ci_sequence_number;

Line: 762

			SELECT	'x'
			FROM	IGS_CA_TYPE ct
			WHERE	ct.S_CAL_CAT = cst_holiday	AND
			EXISTS	(SELECT	'x'
				 FROM	IGS_CA_INST ci,
					IGS_CA_STAT cs
				 WHERE	ci.CAL_TYPE	= ct.CAL_TYPE	AND
					ci.CAL_STATUS	= cs.CAL_STATUS	AND
					cs.s_cal_status	= cst_active	AND
					EXISTS	(SELECT	'x'
					FROM	IGS_CA_DA_INST dai1,
						IGS_CA_DA_INST dai2,
						IGS_CA_DA_INST_PAIR daip
					WHERE	dai1.CAL_TYPE	= ct.CAL_TYPE	AND
						dai1.DT_ALIAS	 = daip.DT_ALIAS    AND
 						dai1.sequence_number	= daip.dai_sequence_number  AND
 						dai1.CAL_TYPE	= daip.CAL_TYPE    AND
 						dai1.ci_sequence_number	= daip.ci_sequence_number  AND
						dai2.DT_ALIAS	= daip.related_dt_alias   AND
 						dai2.sequence_number	= daip.related_dai_sequence_number AND
	 					dai2.CAL_TYPE	= daip.related_cal_type   AND
						dai2.ci_sequence_number	= daip.related_ci_sequence_number AND
						 cp_alias_val BETWEEN TRUNC(dai1.absolute_val) AND
							TRUNC(dai2.absolute_val)));

Line: 820

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 828

						--update the date value and test again.
						v_tmp_alias_val := v_tmp_alias_val + p_cnstrt_resolution;

Line: 873

			SELECT	daoc.S_DT_OFFSET_CONSTRAINT_TYPE,
				daoc.constraint_condition,
				daoc.constraint_resolution
			FROM	IGS_CA_DA_OFFCNT	 daoc
			WHERE	daoc.DT_ALIAS			= p_dt_alias;

Line: 989

		-- 4. Use a loop to select each existiong constraint record.
		--    and check the constraint against the date and if a clash exists,
		--    attempt to resolve it.
		calpl_constraint_resolve (
					v_constraint_count,
					v_mod_count,
					v_alias_val,
					v_message_name);

Line: 1032

	SELECT 	*
	FROM	IGS_CA_DA_OFST
	WHERE	DT_ALIAS = p_dt_alias;

Line: 1037

	SELECT 	*
	FROM	IGS_CA_DA_INST_V
	WHERE	DT_ALIAS = v_dt_alias_offset_rec.offset_dt_alias and
		CAL_TYPE = p_cal_type and
		ci_sequence_number = p_ci_sequence_number
	ORDER BY 	alias_val ASC;

Line: 1110

		SELECT 	daio.DT_ALIAS,
			daio.dai_sequence_number,
			daio.CAL_TYPE,
			daio.ci_sequence_number,
			daio.offset_dt_alias,
			daio.offset_dai_sequence_number,
			daio.offset_cal_type,
			daio.offset_ci_sequence_number,
			daio.day_offset,
			daio.week_offset,
			daio.month_offset,
			daio.year_offset
		FROM	IGS_CA_DA_INST_OFST daio
		WHERE	daio.DT_ALIAS 			= p_dt_alias AND
			daio.dai_sequence_number 	= p_dai_sequence_number AND
			daio.CAL_TYPE 			= p_cal_type AND
			daio.ci_sequence_number 	= p_ci_sequence_number;

Line: 1129

		SELECT 	dai.DT_ALIAS,
			dai.sequence_number,
			dai.CAL_TYPE,
			dai.ci_sequence_number,
			dai.absolute_val
		FROM	IGS_CA_DA_INST	dai
		WHERE	dai.DT_ALIAS 		= v_c_daio_rec.offset_dt_alias AND
			dai.sequence_number 	= v_c_daio_rec.offset_dai_sequence_number AND
			dai.CAL_TYPE 		= v_c_daio_rec.offset_cal_type AND
			dai.ci_sequence_number 	= v_c_daio_rec.offset_ci_sequence_number;

Line: 1140

		SELECT 	daioc.DT_ALIAS,
			daioc.dai_sequence_number,
			daioc.CAL_TYPE,
			daioc.ci_sequence_number
		FROM	IGS_CA_DA_INST_OFCNT	daioc
		WHERE	daioc.DT_ALIAS 		= p_dt_alias AND
			daioc.dai_sequence_number 	= p_dai_sequence_number AND
			daioc.CAL_TYPE 		= p_cal_type AND
			daioc.ci_sequence_number 	= p_ci_sequence_number;

Line: 1264

		SELECT closed_ind
		FROM IGS_CA_TYPE
		WHERE CAL_TYPE = p_cal_type;