APPS.IGS_RE_VAL_CAFOS dependencies on IGS_RE_CDT_FLD_OF_SY_V

Line 27: FROM igs_re_cdt_fld_of_sy_v cafos

23: DECLARE
24:
25: CURSOR c_cafos IS
26: SELECT NVL(Sum(cafos.percentage), 0) total, cafos.fos_type_code
27: FROM igs_re_cdt_fld_of_sy_v cafos
28: WHERE cafos.fos_type_code <> 'CIP'
29: AND cafos.person_id = p_person_id
30: AND cafos.ca_sequence_number = p_ca_sequence_number
31: GROUP BY cafos.fos_type_code