APPS.IGS_AD_GEN_004 dependencies on IGS_PS_VER

Line 351: igs_ps_ver cv

347: FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_APPL_ADMAPPL_V with igs_ad_appl_inst Bug: 3150054
348: igs_ad_appl aav,
349: igs_ca_inst ci1,
350: igs_ca_inst ci2,
351: igs_ps_ver cv
352: WHERE acaiv.crv_version_number = cv.version_number AND
353: acaiv.course_cd = cv.course_cd AND
354: acaiv.person_id = p_person_id AND
355: acaiv.admission_appl_number = p_admission_appl_number AND

Line 638: v_completion_time IGS_PS_VER.std_ft_completion_time%TYPE;

634: DECLARE
635: v_cal_type IGS_PS_OFR.cal_type%TYPE;
636: v_att_gat IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
637: v_comp_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;
638: v_completion_time IGS_PS_VER.std_ft_completion_time%TYPE;
639: v_completion_months IGS_PS_VER.std_ft_completion_time%TYPE;
640: v_completion_dt DATE;
641: v_start_dt_yyyy VARCHAR2(4);
642: v_completion_dt_yyyy VARCHAR2(4);

Line 639: v_completion_months IGS_PS_VER.std_ft_completion_time%TYPE;

635: v_cal_type IGS_PS_OFR.cal_type%TYPE;
636: v_att_gat IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
637: v_comp_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;
638: v_completion_time IGS_PS_VER.std_ft_completion_time%TYPE;
639: v_completion_months IGS_PS_VER.std_ft_completion_time%TYPE;
640: v_completion_dt DATE;
641: v_start_dt_yyyy VARCHAR2(4);
642: v_completion_dt_yyyy VARCHAR2(4);
643: v_context_completion_dt DATE;