APPS.IGS_PS_VAL_GFOS dependencies on IGS_PS_FLD_OF_STUDY

Line 13: FROM IGS_PS_FLD_OF_STUDY

9: RETURN boolean AS
10: v_check CHAR;
11: CURSOR c_check_fos_rec IS
12: SELECT 'x'
13: FROM IGS_PS_FLD_OF_STUDY
14: WHERE govt_field_of_study = p_govt_field_of_study AND
15: IGS_PS_FLD_OF_STUDY.closed_ind = 'N';
16: BEGIN
17: IF p_closed_ind = 'Y' THEN

Line 15: IGS_PS_FLD_OF_STUDY.closed_ind = 'N';

11: CURSOR c_check_fos_rec IS
12: SELECT 'x'
13: FROM IGS_PS_FLD_OF_STUDY
14: WHERE govt_field_of_study = p_govt_field_of_study AND
15: IGS_PS_FLD_OF_STUDY.closed_ind = 'N';
16: BEGIN
17: IF p_closed_ind = 'Y' THEN
18: OPEN c_check_fos_rec;
19: FETCH c_check_fos_rec INTO v_check;