APPS.IGS_AD_GEN_002 dependencies on IGS_PS_TYPE

Line 1237: p_govt_course_type IN IGS_PS_TYPE.govt_course_type%TYPE,

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,
1241: p_course_completed_flag IN VARCHAR2,

Line 1328: v_govt_course_type IGS_PS_TYPE.govt_course_type%TYPE;

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;
1332: v_course_completed_flag VARCHAR2(1);

Line 1411: FROM IGS_PS_TYPE cty

1407: fos.field_of_study = cfos.field_of_study;
1408: CURSOR c_cty (
1409: cp_course_type IGS_PS_VER.course_type%TYPE) IS
1410: SELECT cty.govt_course_type
1411: FROM IGS_PS_TYPE cty
1412: WHERE cty.course_type = cp_course_type;
1413: CURSOR c_pee (
1414: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
1415: SELECT pee.s_encmb_effect_type