APPS.IGS_RE_GEN_002 dependencies on IGS_RE_SCHOLARSHIP

Line 75: FROM IGS_RE_SCHOLARSHIP sch

71: WHERE mil.person_id = p_person_id AND
72: mil.ca_sequence_number = p_ca_sequence_number;
73: CURSOR c_sch IS
74: SELECT 'X'
75: FROM IGS_RE_SCHOLARSHIP sch
76: WHERE sch.person_id = p_person_id AND
77: sch.ca_sequence_number = p_ca_sequence_number AND
78: sch.start_dt <= p_effective_dt AND
79: NVL(sch.end_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) >= p_effective_dt;

Line 143: --Validate for existence of research IGS_RE_CANDIDATURE IGS_RE_SCHOLARSHIP

139: CLOSE c_mil;
140: END IF;
141: END IF;
142: IF p_check_scholarship THEN
143: --Validate for existence of research IGS_RE_CANDIDATURE IGS_RE_SCHOLARSHIP
144: OPEN c_sch;
145: FETCH c_sch INTO v_sch_dummy_rec;
146: IF (c_sch%FOUND) THEN
147: CLOSE c_sch;