APPS.IGS_FI_VAL_UFT SQL Statements

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

Line: 23

  		SELECT	s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	fee_type = cp_fee_type;

Line: 72

  		SELECT	s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	fee_type = cp_fee_type;

Line: 122

  		SELECT	'x'
  		FROM	IGS_FI_UNIT_FEE_TRG uft
  		WHERE	uft.fee_cat			= p_fee_cat AND
  			uft.fee_cal_type 		= p_fee_cal_type AND
  			uft.fee_ci_sequence_number 	= p_fee_ci_sequence_number AND
  			uft.fee_type			= p_fee_type AND
  			uft.unit_cd			= p_unit_cd AND
  			uft.sequence_number		<> NVL(p_sequence_number,0) AND
  			NVL(uft.version_number,0)	= NVL(p_version_number,0) AND
  			NVL(uft.cal_type,'NULL')	= NVL(p_cal_type,'NULL') AND
  			NVL(uft.ci_sequence_number,0)	= NVL(p_ci_sequence_number,0) AND
  			NVL(uft.location_cd,'NULL')	= NVL(p_location_cd,'NULL') AND
  			NVL(uft.unit_class,'NULL') 	= NVL(p_unit_class,'NULL') AND
  			uft.create_dt			<> p_create_dt AND
  			NVL(uft.fee_trigger_group_number,0) = NVL(p_fee_trigger_group_number,0) AND
  			uft.logical_delete_dt IS NULL;

Line: 176

  		SELECT	'X'
  		FROM	IGS_PS_UNIT_OFR_OPT	uoo
  		WHERE	uoo.unit_cd			= p_unit_cd AND
  			(p_cal_type  IS NULL OR
  			uoo.cal_type			= p_cal_type) AND
  			(p_ci_sequence_number IS NULL OR
  			(uoo.cal_type			= p_cal_type AND
  			uoo.ci_sequence_number		= p_ci_sequence_number)) AND
  			(p_location_cd  IS NULL OR
  			uoo.location_cd			= p_location_cd) AND
  			(p_unit_class  IS NULL OR
  			uoo.unit_class			= p_unit_class);