APPS.IGS_AD_APPL_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 115: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

111: v_person_encmb_chk_ind VARCHAR2(1);
112: v_cond_offer_fee_allowed_ind VARCHAR2(1);
113: cst_error CONSTANT VARCHAR2(1) := 'E';
114: cst_warn CONSTANT VARCHAR2(1) := 'W';
115: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
116:
117: CURSOR c_apcs (
118: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
119: cp_s_admission_process_type

Line 129: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS

125: s_admission_process_type = cp_s_admission_process_type AND
126: step_group_type <> 'TRACK' ;-- 2402377
127:
128:
129: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
130: SELECT birth_date
131: FROM igs_pe_person_base_v
132: WHERE person_id =p_person_id ;
133:

Line 131: FROM igs_pe_person_base_v

127:
128:
129: CURSOR c_birth_date(p_person_id igs_pe_person_base_v.person_id%TYPE) IS
130: SELECT birth_date
131: FROM igs_pe_person_base_v
132: WHERE person_id =p_person_id ;
133:
134: BEGIN
135: v_title_required_ind := 'Y';