APPS.IGS_FI_VAL_FTG SQL Statements

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

Line: 16

  		SELECT	s_fee_trigger_cat
  		FROM	IGS_FI_FEE_TYPE
  		WHERE	FEE_TYPE = cp_fee_type;

Line: 60

  		SELECT	'x'
  		FROM	IGS_PS_FEE_TRG cft
  		WHERE	cft.FEE_CAT			= p_fee_cat AND
  			cft.fee_cal_type 		= p_fee_cal_type AND
  			cft.fee_ci_sequence_number 	= p_fee_ci_sequence_number AND
  			cft.FEE_TYPE			= p_fee_type AND
  			NVL(cft.fee_trigger_group_number,0)	= p_fee_trigger_group_num AND
  			cft.logical_delete_dt IS NULL;

Line: 69

  		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
  			NVL(uft.fee_trigger_group_number,0)	= p_fee_trigger_group_num AND
  			uft.logical_delete_dt IS NULL;

Line: 78

  		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
  			NVL(usft.fee_trigger_group_number,0)	= p_fee_trigger_group_num AND
  			usft.logical_delete_dt IS NULL;