APPS.IGS_PE_PASSPORT_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 165: FROM igs_pe_person_base_v

161: */
162: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
163: IS
164: SELECT birth_date
165: FROM igs_pe_person_base_v
166: WHERE person_id = cp_person_id;
167:
168: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
169: BEGIN

Line 168: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

164: SELECT birth_date
165: FROM igs_pe_person_base_v
166: WHERE person_id = cp_person_id;
167:
168: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
169: BEGIN
170: IF p_inserting or p_updating THEN
171: OPEN get_dob_dt_cur(new_references.person_id);
172: FETCH get_dob_dt_cur INTO l_birth_dt;