APPS.IGS_PS_VAL_CFOS dependencies on IGS_PS_FLD_OF_STUDY

Line 10: v_closed_ind IGS_PS_FLD_OF_STUDY.closed_ind%TYPE;

6: FUNCTION crsp_val_cfos_fos(
7: p_field_of_study IN VARCHAR2 ,
8: p_message_name OUT NOCOPY VARCHAR2)
9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_FLD_OF_STUDY.closed_ind%TYPE;
11: CURSOR c_field_of_study IS
12: SELECT closed_ind
13: FROM IGS_PS_FLD_OF_STUDY
14: WHERE field_of_study = p_field_of_study;

Line 13: FROM IGS_PS_FLD_OF_STUDY

9: RETURN BOOLEAN AS
10: v_closed_ind IGS_PS_FLD_OF_STUDY.closed_ind%TYPE;
11: CURSOR c_field_of_study IS
12: SELECT closed_ind
13: FROM IGS_PS_FLD_OF_STUDY
14: WHERE field_of_study = p_field_of_study;
15: BEGIN
16: OPEN c_field_of_study;
17: FETCH c_field_of_study INTO v_closed_ind;