APPS.IGS_FI_VAL_FCFL SQL Statements

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

Line: 29

  		SELECT	'x'
  		FROM	IGS_FI_FEE_STR_STAT		fss
  		WHERE	fss.fee_structure_status	= cp_fee_liability_status AND
  			fss.s_fee_structure_status	= cst_active;

Line: 36

  		SELECT	cat.s_cal_cat,
  			cs.s_cal_status
  		FROM	IGS_CA_INST			ci,
  			IGS_CA_STAT			cs,
  			IGS_CA_TYPE			cat
  		WHERE	ci.cal_type			= cp_cal_type AND
  			ci.sequence_number		= cp_sequence_number AND
  			ci.cal_type			= cat.cal_type AND
  			ci.cal_status			= cs.cal_status;

Line: 101

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

Line: 106

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

Line: 201

  		SELECT	fss.s_fee_structure_status
  		FROM	IGS_FI_F_TYP_CA_INST	ftci,
  			IGS_FI_FEE_STR_STAT	fss
  		WHERE	ftci.fee_cal_type = p_fee_cal_type AND
  			ftci.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			ftci.fee_type = p_fee_type AND
  			ftci.fee_type_ci_status = fss.fee_structure_status;

Line: 209

  		SELECT	fss.s_fee_structure_status
  		FROM	IGS_FI_FEE_STR_STAT	fss
  		WHERE	fss.fee_structure_status = p_fee_status;

Line: 213

  		SELECT	fss.s_fee_structure_status
  		FROM	IGS_FI_F_CAT_CA_INST	fcci,
  			IGS_FI_FEE_STR_STAT	fss
  		WHERE	fcci.fee_cal_type = p_fee_cal_type AND
  			fcci.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			fcci.fee_cat = p_fee_cat AND
  			fcci.fee_cat_ci_status = fss.fee_structure_status;

Line: 296

  	-- Validate insert of the IGS_FI_F_CAT_FEE_LBL.
  	-- When the fee category currency does not match the local currency
  	-- check there are no inherited definitions taken from the
  	-- fee type calendar instance. All definitions at the FTCI level
  	-- operate under the local currency
  DECLARE
  	v_check			CHAR;

Line: 307

          SELECT currency_cd
          FROM   igs_fi_control;

Line: 311

  		SELECT	currency_cd
  		FROM	IGS_FI_FEE_CAT
  		WHERE	fee_cat	= p_fee_cat;

Line: 316

  		SELECT	'x'
  		FROM	IGS_FI_FEE_RET_SCHD
  		WHERE	fee_cal_type = p_fee_cal_type AND
  			fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			s_relation_type = 'FTCI' AND
  			fee_type = p_fee_type;

Line: 325

  		SELECT	'x'
  		FROM	IGS_FI_FEE_AS_RATE
  		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 = 'FTCI' AND
  			logical_delete_dt IS NULL;