APPS.IGS_EN_VAL_SCT dependencies on IGS_AD_APPL

Line 391: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

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;
395: CURSOR c_cv IS

Line 402: FROM IGS_AD_APPL aa

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
402: FROM IGS_AD_APPL aa
403: WHERE aa.person_id = p_person_id AND
404: aa.admission_appl_number = p_admission_appl_number;
405: CURSOR c_acai IS
406: SELECT adm_outcome_status,