APPS.IGS_FI_VAL_FC SQL Statements

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

Line: 36

  	-- Validate update of the IGS_FI_FEE_CAT.closed_ind.
  DECLARE
  	v_check		CHAR;

Line: 41

  		SELECT	'x'
  		FROM	IGS_FI_FEE_CAT_MAP
  		WHERE	fee_cat  = p_fee_cat AND
  			dflt_cat_ind = 'Y';

Line: 74

  		SELECT	fee_cal_type,
  			fee_ci_sequence_number,
  			FEE_TYPE
  		FROM	IGS_FI_F_CAT_FEE_LBL
  		WHERE	fee_cat = cp_fee_cat;

Line: 84

  		SELECT	rate_number
  		FROM	IGS_FI_FEE_AS_RATE
  		WHERE	fee_type= cp_fee_type AND
  			fee_cal_type = cp_fee_cal_type AND
  			fee_ci_sequence_number = cp_fee_ci_sequence_number AND
  			s_relation_type = cst_fcfl AND
  			fee_cat = cp_fee_cat;

Line: 96

            SELECT range_number
  		FROM	IGS_FI_ELM_RANGE_RT
  		WHERE	FEE_TYPE = cp_fee_type AND
  			fee_cal_type = cp_fee_cal_type AND
  			fee_ci_sequence_number = cp_fee_ci_sequence_number AND
  			s_relation_type = cst_fcfl AND
  			fee_cat = cp_fee_cat AND
  			logical_delete_dt IS NULL;