APPS.IGS_EN_VAL_USFT SQL Statements

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

Line: 29

  		SELECT	s_fee_trigger_cat

  		FROM	IGS_FI_FEE_TYPE

  		WHERE	fee_type = cp_fee_type;

Line: 123

  		SELECT	s_fee_trigger_cat

  		FROM	IGS_FI_FEE_TYPE

  		WHERE	fee_type = cp_fee_type;

Line: 221

  		SELECT	'x'

  		FROM	IGS_EN_UNITSETFEETRG usft

  		WHERE	usft.fee_cat			= p_fee_cat AND

  			usft.fee_cal_type 		= p_fee_cal_type AND

  			usft.fee_ci_sequence_number 	= p_fee_ci_sequence_number AND

  			usft.fee_type			= p_fee_type AND

  			usft.unit_set_cd		= p_unit_set_cd AND

  			NVL(usft.version_number,0)	= NVL(p_version_number,0) AND

  			usft.create_dt			<> p_create_dt AND

  			NVL(usft.fee_trigger_group_number,0) = NVL(p_fee_trigger_group_number,0) AND

  			usft.logical_delete_dt IS NULL;

Line: 326

  		SELECT	'X'

  		FROM	IGS_EN_UNIT_SET		us,

  			IGS_EN_UNIT_SET_STAT	uss

  		WHERE	us.unit_set_cd		= p_unit_set_cd AND

  			us.version_number		= p_version_number AND

  			us.unit_set_status		= uss.unit_set_status AND

  			uss.s_unit_set_status	= 'INACTIVE';