APPS.IGS_RE_VAL_TEX dependencies on IGS_RE_CDT_FLD_OF_SY_V

Line 174: FROM igs_re_cdt_fld_of_sy_v cfos

170: rst.principal_supervisor_ind = 'Y';
171: v_rsup_exists VARCHAR2(1);
172: CURSOR c_cfos IS
173: SELECT NVL(Sum(cfos.percentage), 0) total, cfos.fos_type_code
174: FROM igs_re_cdt_fld_of_sy_v cfos
175: WHERE cfos.fos_type_code <> 'CIP'
176: AND cfos.person_id = p_person_id
177: AND cfos.ca_sequence_number = p_ca_sequence_number
178: GROUP BY cfos.fos_type_code