APPS.IGS_ST_GEN_003 dependencies on IGS_PS_CATEGORISE

Line 242: v_crs_cat IGS_PS_CATEGORISE.course_cat%TYPE;

238: 'ENROLLED';
239: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE :=
240: 'DISCONTIN';
241: v_unit_cat IGS_PS_UNIT_CATEGORY.unit_cat%TYPE;
242: v_crs_cat IGS_PS_CATEGORISE.course_cat%TYPE;
243: v_resp_ou_cd IGS_PS_VER.responsible_org_unit_cd%TYPE;
244: v_resp_ou_start_dt IGS_PS_VER.responsible_ou_start_dt%TYPE;
245: v_govt_crs_type IGS_PS_TYPE.govt_course_type%TYPE;
246: v_award_crs_ind IGS_PS_TYPE.award_course_ind%TYPE;

Line 265: FROM IGS_PS_CATEGORISE crc

261: cst_govt_report,
262: cst_govt_noreport );
263: CURSOR c_crc IS
264: SELECT crc.course_cat
265: FROM IGS_PS_CATEGORISE crc
266: WHERE crc.course_cd = p_course_cd AND
267: crc.version_number = p_crv_version_number AND
268: crc.course_cat IN (
269: cst_govt_report,