APPS.IGS_AD_TEST_RESULTS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 405: FROM igs_pe_person_base_v

401: */
402: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
403: IS
404: SELECT birth_date
405: FROM igs_pe_person_base_v
406: WHERE person_id = cp_person_id;
407:
408: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
409: BEGIN

Line 408: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

404: SELECT birth_date
405: FROM igs_pe_person_base_v
406: WHERE person_id = cp_person_id;
407:
408: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
409: BEGIN
410: IF p_inserting or p_updating THEN
411: OPEN get_dob_dt_cur(new_references.person_id);
412: FETCH get_dob_dt_cur INTO l_birth_dt;