APPS.IGS_EN_VAL_SCA dependencies on IGS_PE_PERSON

Line 2139: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;

2135: cst_sca CONSTANT VARCHAR2(4) := 'SCA';
2136: -- Variables
2137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2138: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
2139: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
2140: v_candidature_exists_ind VARCHAR2(1);
2141: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
2142: v_message_name varchar2(30);
2143: -- Temporary variables

Line 2189: FROM igs_pe_person_base_v

2185: acaiv.sequence_number = cp_adm_sequence_number;
2186: v_acaiv_rec c_acaiv%ROWTYPE;
2187: CURSOR c_person IS
2188: SELECT birth_date date_of_birth
2189: FROM igs_pe_person_base_v
2190: WHERE person_id = p_person_id;
2191: CURSOR c_daiv_secc IS
2192: SELECT daiv.alias_val
2193: FROM IGS_CA_DA_INST_V daiv,

Line 2437: --Retrieve the birth_dt from IGS_PE_PERSON where person_id = p_person_id

2433: RETURN TRUE;
2434: END IF;
2435: END IF; -- v_adm_adm_appl_number IS NOT NULL
2436: END IF; -- v_commencement_dt_validated
2437: --Retrieve the birth_dt from IGS_PE_PERSON where person_id = p_person_id
2438: OPEN c_person;
2439: FETCH c_person INTO v_birth_dt;
2440: CLOSE c_person;
2441: IF v_birth_dt IS NULL THEN