APPS.IGS_ST_GEN_004 dependencies on IGS_PS_VER

Line 51: cp_course_cd IGS_PS_VER.course_cd%TYPE,

47: cgr.course_group_cd = cgm.course_group_cd AND
48: cgt.course_group_type = cgr.course_group_type AND
49: cgt.s_course_group_type = cst_combined;
50: CURSOR c_cfos (
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

Line 52: cp_version_number IGS_PS_VER.version_number%TYPE) IS

48: cgt.course_group_type = cgr.course_group_type AND
49: cgt.s_course_group_type = cst_combined;
50: CURSOR c_cfos (
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

Line 354: v_old_course_cd IGS_PS_VER.course_cd%TYPE;

350: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;
351: v_fee_cat IGS_FI_FEE_CAT.fee_cat%TYPE;
352: v_old_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
353: v_old_person_id IGS_PE_PERSON.person_id%TYPE;
354: v_old_course_cd IGS_PS_VER.course_cd%TYPE;
355: v_appl_owner all_indexes.owner%TYPE;
356: v_start_dt DATE;
357: v_end_dt DATE;
358: v_start_dt_2 DATE;