APPS.IGS_RE_GEN_002 dependencies on IGS_AD_APPL

Line 201: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

197: cst_rsup CONSTANT VARCHAR2(10) := 'RSUP';
198: v_start_dt DATE;
199: v_research_type_ind VARCHAR2(1) DEFAULT 'N';
200: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
201: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
202: v_research_unit_start_dt DATE;
203: CURSOR c_ca IS
204: SELECT ca.sca_course_cd,
205: ca.acai_admission_appl_number,

Line 242: FROM IGS_AD_APPL aa,

238: CURSOR c_apcs (
239: cp_adm_appl_num IGS_RE_CANDIDATURE.acai_admission_appl_number%TYPE)
240: IS
241: SELECT aa.s_admission_process_type
242: FROM IGS_AD_APPL aa,
243: IGS_AD_PRCS_CAT_STEP apcs
244: WHERE aa.person_id = p_person_id AND
245: aa.admission_appl_number = cp_adm_appl_num AND
246: aa.admission_cat = apcs.admission_cat AND