APPS.IGS_FI_VAL_FCCI SQL Statements

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

Line: 36

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

Line: 43

  		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: 105

  ||  pmarada         28-jul-2005  Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row
  ||  vvutukur        23-Jul-2002  Bug#2425767.Removed references to payment_hierarchy_rank(from the call
  ||                               to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row).
  ----------------------------------------------------------------------------*/
  	gv_other_detail		VARCHAR2(255);

Line: 116

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

Line: 120

 		SELECT	fcfl.*, fcfl.rowid  -- kdande -> rowid was added to make a call to Update_Row TBH.
  		FROM	IGS_FI_F_CAT_FEE_LBL	fcfl
  		WHERE	fcfl.fee_cal_type = p_fee_cal_type AND
  			fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
    			fcfl.fee_cat =p_fee_cat AND
  			fcfl.fee_liability_status in
  				(select fss.fee_structure_status
  				 from   IGS_FI_FEE_STR_STAT fss
  				 where  fss.fee_structure_status = fcfl.fee_liability_status
  				 and    fss.s_fee_structure_status = 'ACTIVE')
  		FOR UPDATE OF fcfl.fee_liability_status NOWAIT;

Line: 135

  	-- to 'INACTIVE' update the IGS_FI_F_CAT_FEE_LBL.fee_liability_status
  	-- in related records to 'INACTIVE'.
  	p_message_name := NULL;

Line: 146

  	-- 2. Update any related IGS_FI_F_CAT_FEE_LBL records.
  	OPEN c_fcfl;

Line: 149

   	FETCH c_fcfl INTO fcfl_rec; -- kdande -> Added fcfl_rec for use in Update_Row DML.

Line: 156

        IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row (
          x_rowid => fcfl_rec.rowid,
          x_fee_cat => fcfl_rec.fee_cat,
          x_fee_ci_sequence_number => fcfl_rec.fee_ci_sequence_number,
          x_fee_type => fcfl_rec.fee_type,
          x_fee_cal_type => fcfl_rec.fee_cal_type,
          x_fee_liability_status => p_fee_cat_ci_status,
          x_start_dt_alias => fcfl_rec.start_dt_alias,
          x_start_dai_sequence_number => fcfl_rec.start_dai_sequence_number,
          x_s_chg_method_type => fcfl_rec.s_chg_method_type,
          x_rul_sequence_number => fcfl_rec.rul_sequence_number,
          x_waiver_calc_flag => fcfl_rec.waiver_calc_flag
        );

Line: 172

  	-- 4. Update Successful
  	RETURN TRUE;

Line: 208

  		SELECT	fss.s_fee_structure_status
  		FROM	IGS_FI_FEE_STR_STAT	fss
  		WHERE	fss.FEE_STRUCTURE_STATUS = cp_fcci_status;

Line: 212

  		SELECT	fcfl.fee_cat
  		FROM	IGS_FI_F_CAT_FEE_LBL	fcfl
  		WHERE	fcfl.fee_cat = p_fee_cat AND
  			fcfl.fee_cal_type = p_fee_cal_type AND
  			fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;

Line: 218

  		SELECT	fcfl.fee_cat
  		FROM	IGS_FI_F_CAT_FEE_LBL		fcfl,
  			IGS_FI_FEE_STR_STAT	fss
  		WHERE	fcfl.fee_cat = p_fee_cat AND
  			fcfl.fee_cal_type = p_fee_cal_type AND
  			fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
  			fcfl.fee_liability_status = fss.fee_structure_status AND
  			fss.s_fee_structure_status = cst_active;

Line: 294

  		SELECT	alias_val
  		FROM	IGS_CA_DA_INST_V
  		WHERE	cal_type = cp_fee_cal_type AND
  			ci_sequence_number = cp_fee_ci_sequence_number AND
  			dt_alias = cp_dt_alias AND
  			sequence_number = cp_dai_sequence_number;

Line: 371

  		SELECT	closed_ind
  		FROM	IGS_FI_FEE_STR_STAT
  		WHERE	fee_structure_status = p_fee_structure_status;

Line: 406

  		SELECT	cat.s_cal_cat,
  			cs.s_cal_status
  		FROM	IGS_CA_INST	ci,
  			IGS_CA_TYPE	cat,
  			IGS_CA_STAT	cs
  		WHERE	ci.cal_type = p_fee_cal_type AND
  			ci.sequence_number = p_fee_ci_sequence_number AND
  			ci.cal_type = cat.CAL_TYPE AND
  			ci.cal_status  = cs.CAL_STATUS;