APPS.IGS_FI_VAL_FC dependencies on IGS_FI_ELM_RANGE_RT

Line 97: FROM IGS_FI_ELM_RANGE_RT

93: cp_fee_cal_type IGS_FI_F_CAT_FEE_LBL.fee_cal_type%TYPE,
94: cp_fee_ci_sequence_number IGS_FI_F_CAT_FEE_LBL.fee_ci_sequence_number%TYPE,
95: cp_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE)IS
96: SELECT range_number
97: FROM IGS_FI_ELM_RANGE_RT
98: WHERE FEE_TYPE = cp_fee_type AND
99: fee_cal_type = cp_fee_cal_type AND
100: fee_ci_sequence_number = cp_fee_ci_sequence_number AND
101: s_relation_type = cst_fcfl AND

Line 130: -- Check if any associated IGS_FI_ELM_RANGE_RT records exist for the

126: CLOSE c_far;
127: p_message_name := 'IGS_FI_FEECATFEELIAB_EXIST';
128: RETURN TRUE;
129: END IF;
130: -- Check if any associated IGS_FI_ELM_RANGE_RT records exist for the
131: -- IGS_FI_F_CAT_FEE_LBL record. If so, return a warning.
132: OPEN c_err(
133: v_fcfl_rec.FEE_TYPE,
134: v_fcfl_rec.fee_cal_type,