APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_CA_DA_INST_V

Line 205: FROM igs_ca_da_inst_v

201: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
202: cp_date_alias igs_ca_da_inst.dt_alias%TYPE)
203: IS
204: SELECT alias_val
205: FROM igs_ca_da_inst_v
206: WHERE cal_type = cp_fee_cal_type
207: AND ci_sequence_number = cp_fee_ci_sequence_number
208: AND dt_alias = cp_date_alias
209: ORDER BY alias_val DESC;

Line 210: l_refund_dt_val igs_ca_da_inst_v.alias_val%TYPE;

206: WHERE cal_type = cp_fee_cal_type
207: AND ci_sequence_number = cp_fee_ci_sequence_number
208: AND dt_alias = cp_date_alias
209: ORDER BY alias_val DESC;
210: l_refund_dt_val igs_ca_da_inst_v.alias_val%TYPE;
211:
212: BEGIN
213: -- If the mandatory parameters are not passed then the function returnd FALSE
214: IF (p_fee_cal_type IS NULL OR p_fee_ci_sequence_number IS NULL) THEN

Line 234: -- Get the Alias Value from the igs_ca_da_inst_v view, returns FALSE when no data found

230: IF (l_refund_dt_alias IS NULL) THEN
231: RETURN FALSE;
232: END IF;
233:
234: -- Get the Alias Value from the igs_ca_da_inst_v view, returns FALSE when no data found
235: OPEN cur_alias_val(p_fee_cal_type, p_fee_ci_sequence_number, l_refund_dt_alias);
236: FETCH cur_alias_val INTO l_refund_dt_val;
237: IF cur_alias_val%NOTFOUND THEN
238: CLOSE cur_alias_val;