APPS.IGS_FI_VAL_FRTNS SQL Statements

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

Line: 30

  		SELECT	'x'
  		FROM	IGS_FI_FEE_RET_SCHD
  		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;

Line: 129

  		SELECT	s_fee_trigger_cat,
  			s_fee_type,
  			optional_payment_ind
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	FEE_TYPE = cp_fee_type;

Line: 194

  	-- Validate insert of the IGS_FI_FEE_RET_SCHD.
  	-- When adding an entry at the FTCI level;

Line: 205

  		SELECT	currency_cd
  		FROM	IGS_FI_FEE_CAT
  		WHERE	FEE_CAT	= cp_fee_cat;

Line: 209

  		SELECT	FEE_CAT
  		FROM	IGS_FI_F_CAT_FEE_LBL
  		WHERE	fee_cal_type = p_fee_cal_type AND
  			fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			FEE_TYPE = p_fee_type;

Line: 215

          SELECT currency_cd
          FROM   igs_fi_control;