APPS.IGS_FI_VAL_FAS dependencies on IGS_FI_FEE_AS_RT

Line 276: FROM IGS_FI_FEE_AS_RT cfar

272: DECLARE
273: v_cfar_rec CHAR;
274: CURSOR c_cfar IS
275: SELECT 'X'
276: FROM IGS_FI_FEE_AS_RT cfar
277: WHERE cfar.person_id = p_person_id AND
278: cfar.course_cd = p_course_cd AND
279: cfar.fee_type = p_fee_type AND
280: p_effective_dt BETWEEN cfar.start_dt AND

Line 292: --Determine if a IGS_FI_FEE_AS_RT exists

288: p_fee_type IS NULL OR
289: p_effective_dt IS NULL) THEN
290: RETURN TRUE;
291: END IF;
292: --Determine if a IGS_FI_FEE_AS_RT exists
293: OPEN c_cfar;
294: FETCH c_cfar INTO v_cfar_rec;
295: IF (c_cfar%FOUND) THEN
296: p_message_name := 'IGS_FI_STUD_ACTIVE_CONT_FEEAS';