APPS.IGS_ST_GEN_004 dependencies on IGS_PS_FLD_OF_STUDY

Line 39: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;

35: -- DEETYA element 389
36: DECLARE
37: cst_combined CONSTANT IGS_PS_GRP_TYPE.s_course_group_type%TYPE := 'COMBINED';
38: v_dummy VARCHAR2(1);
39: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
40: CURSOR c_cgm_cgr_cgt IS
41: SELECT 'X'
42: FROM IGS_PS_GRP_MBR cgm,
43: IGS_PS_GRP cgr,

Line 55: IGS_PS_FLD_OF_STUDY fos

51: cp_course_cd IGS_PS_VER.course_cd%TYPE,
52: cp_version_number IGS_PS_VER.version_number%TYPE) IS
53: SELECT fos.govt_field_of_study
54: FROM IGS_PS_FIELD_STUDY cfos,
55: IGS_PS_FLD_OF_STUDY fos
56: WHERE cfos.course_cd = cp_course_cd AND
57: cfos.version_number = cp_version_number AND
58: fos.field_of_study = cfos.field_of_study
59: ORDER BY