APPS.IGS_ST_GEN_003 dependencies on IGS_PS_FLD_OF_STUDY

Line 1300: IGS_PS_FLD_OF_STUDY fos

1296: DECLARE
1297: CURSOR c_cfos_fos IS
1298: SELECT fos.govt_field_of_study
1299: FROM IGS_PS_FIELD_STUDY cfos,
1300: IGS_PS_FLD_OF_STUDY fos
1301: WHERE cfos.course_cd = p_course_cd AND
1302: cfos.version_number = p_version_number AND
1303: cfos.major_field_ind = 'Y' AND
1304: fos.field_of_study = cfos.field_of_study;

Line 1305: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;

1301: WHERE cfos.course_cd = p_course_cd AND
1302: cfos.version_number = p_version_number AND
1303: cfos.major_field_ind = 'Y' AND
1304: fos.field_of_study = cfos.field_of_study;
1305: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
1306: BEGIN
1307: -- Cursor handling
1308: OPEN c_cfos_fos;
1309: FETCH c_cfos_fos INTO v_govt_field_of_study;