APPS.IGS_EN_GEN_002 dependencies on IGS_PS_VER

Line 296: IGS_PS_VER crv

292: CURSOR c_sca IS
293: SELECT MIN(sca.commencement_dt) commencement_dt
294: FROM IGS_PS_STDNT_TRN sct,
295: IGS_EN_STDNT_PS_ATT sca,
296: IGS_PS_VER crv
297: WHERE sct.person_id = p_person_id AND
298: sct.course_cd = p_course_cd AND
299: sct.person_id = sca.person_id AND
300: sct.transfer_course_cd = sca.course_cd AND

Line 339: IGS_PS_VER crv

335: IGS_AD_PS_APPL_INST acai,
336: IGS_AD_APPL aa,
337: IGS_CA_INST ci,
338: IGS_AD_PS_APPL aca,
339: IGS_PS_VER crv
340: WHERE acai.person_id = p_person_id AND
341: aa.person_id = acai.person_id AND
342: acai.admission_appl_number = p_adm_admission_appl_number AND
343: aa.admission_appl_number = acai.admission_appl_number AND

Line 628: v_crv_rec IGS_PS_VER.std_annual_load%TYPE;

624: -- IGS_PS_COURSE.
625: DECLARE
626: v_atl_rec IGS_EN_ATD_TYPE_LOAD.default_eftsu%TYPE;
627: v_cal_rec IGS_PS_ANL_LOAD.annual_load_val%TYPE;
628: v_crv_rec IGS_PS_VER.std_annual_load%TYPE;
629: v_annual_load NUMBER;
630: CURSOR c_atl IS
631: SELECT atl.default_eftsu
632: FROM IGS_EN_ATD_TYPE_LOAD atl

Line 643: FROM IGS_PS_VER crv

639: cal.version_number = p_version_number
640: ORDER BY yr_num ASC;
641: CURSOR c_crv IS
642: SELECT std_annual_load
643: FROM IGS_PS_VER crv
644: WHERE crv.course_cd = p_course_cd AND
645: crv.version_number = p_version_number;
646: BEGIN
647: v_annual_load := 0;