APPS.IGS_AD_GEN_002 dependencies on IGS_PS_FLD_OF_STUDY

Line 1236: p_govt_field_of_study IN IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE,

1232: ---------------
1233: PROCEDURE admpl_write_course_header (
1234: p_course_cd IN IGS_PS_VER.course_cd%TYPE,
1235: p_course_title IN IGS_PS_VER.title%TYPE,
1236: p_govt_field_of_study IN IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE,
1237: p_govt_course_type IN IGS_PS_TYPE.govt_course_type%TYPE,
1238: p_honours_flag IN IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE,
1239: p_exclusion_flag IN VARCHAR2,
1240: p_all_subjects_inc_flag IN VARCHAR2,

Line 1327: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;

1323: v_output_student VARCHAR2(71);
1324: v_output_subject VARCHAR2(69);
1325: v_last_course_cd IGS_PS_VER.course_cd%TYPE;
1326: v_course_title IGS_PS_VER.title%TYPE;
1327: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
1328: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;
1329: v_honours_flag IGS_GR_HONOURS_LEVEL.govt_honours_level%TYPE;
1330: v_exclusion_flag VARCHAR2(1);
1331: v_s_encmb_effect_type IGS_PE_COURSE_EXCL.s_encmb_effect_type%TYPE;

Line 1402: FROM IGS_PS_FLD_OF_STUDY fos,

1398: CURSOR c_fos_cfos (
1399: cp_course_cd IGS_PS_VER.course_cd%TYPE,
1400: cp_version_number IGS_PS_VER.version_number%TYPE) IS
1401: SELECT fos.govt_field_of_study
1402: FROM IGS_PS_FLD_OF_STUDY fos,
1403: IGS_PS_FIELD_STUDY cfos
1404: WHERE cfos.course_cd = cp_course_cd AND
1405: cfos.version_number = cp_version_number AND
1406: cfos.major_field_ind = 'Y' AND