APPS.IGS_EN_VAL_SCT dependencies on IGS_PS_VER

Line 390: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;

386: cst_completed CONSTANT VARCHAR2(9) := 'COMPLETED';
387: cst_transfer CONSTANT VARCHAR2(8) := 'TRANSFER';
388: cst_unconfirm CONSTANT VARCHAR2(9) := 'UNCONFIRM';
389: v_dummy VARCHAR2(1);
390: v_generic_course_ind IGS_PS_VER.generic_course_ind%TYPE;
391: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
392: v_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;
393: v_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;
394: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 397: FROM IGS_PS_VER cv

393: v_adm_offer_resp_status IGS_AD_PS_APPL_INST.adm_offer_resp_status%TYPE;
394: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
395: CURSOR c_cv IS
396: SELECT generic_course_ind
397: FROM IGS_PS_VER cv
398: WHERE cv.course_cd = p_course_cd AND
399: cv.version_number = p_crv_version_number;
400: CURSOR c_aa IS
401: SELECT s_admission_process_type