APPS.IGS_FI_VAL_ER SQL Statements

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

Line: 25

  		SELECT	'x'
  		FROM	IGS_FI_ELM_RANGE
  		WHERE	fee_type 		= p_fee_type AND
  			fee_cal_type 		= p_fee_cal_type AND
  			fee_ci_sequence_number 	= p_fee_ci_sequence_number AND
  			s_relation_type 	= cp_s_relation_type AND
  			logical_delete_dt	IS NULL;

Line: 104

  		SELECT	er.lower_range,
  			er.upper_range
  		FROM	IGS_FI_ELM_RANGE	er
  		WHERE	er.fee_type 		= p_fee_type AND
  			er.fee_cal_type 	= p_fee_cal_type AND
  			er.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			er.s_relation_type 	= p_s_relation_type AND
  			nvl(er.fee_cat,'NULL')	= nvl(p_fee_cat,'NULL') AND
  			er.range_number		<> nvl(p_range_number,0) AND
  			er.logical_delete_dt 	IS NULL;

Line: 204

  		SELECT	ftci.s_chg_method_type
  		FROM	IGS_FI_F_TYP_CA_INST ftci
  		WHERE	ftci.fee_type = p_fee_type AND
  			ftci.fee_cal_type = p_fee_cal_type AND
  			ftci.fee_ci_sequence_number = p_fee_ci_sequence_number;

Line: 210

  		SELECT	ftfl.s_chg_method_type
  		FROM	IGS_FI_F_CAT_FEE_LBL ftfl
  		WHERE	ftfl.fee_type = p_fee_type AND
  			ftfl.fee_cal_type = p_fee_cal_type AND
  			ftfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			ftfl.fee_cat = p_fee_cat;

Line: 217

  		SELECT	ft.s_fee_type
  		FROM	IGS_FI_FEE_TYPE ft
  		WHERE	ft.fee_type = p_fee_type;

Line: 374

  		SELECT	s_fee_trigger_cat,
  			s_fee_type
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	fee_type = p_fee_type;