APPS.IGS_ST_GEN_004 dependencies on IGS_PS_TYPE

Line 350: v_award_course_ind IGS_PS_TYPE.award_course_ind%TYPE;

346: v_command VARCHAR2(600);
347: v_command_cursor INTEGER;
348: v_ret INTEGER;
349: v_start_dt_time DATE;
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;

Line 451: IGS_PS_TYPE ct,

447: ct.award_course_ind,
448: uoo.uoo_id,
449: ess.sua_location_cd
450: FROM IGS_EN_ST_SNAPSHOT ess,
451: IGS_PS_TYPE ct,
452: igs_ps_unit_ofr_opt uoo
453: WHERE ess.snapshot_dt_time = cp_dt_time AND
454: ess.govt_reportable_ind <> 'X' AND
455: ct.course_type = ess.course_type AND