APPS.IGS_PE_VISA_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 153: FROM igs_pe_person_base_v

149:
150: CURSOR get_dob_dt_cur(cp_person_id igs_pe_passport.person_id%TYPE)
151: IS
152: SELECT birth_date
153: FROM igs_pe_person_base_v
154: WHERE person_id = cp_person_id;
155:
156: CURSOR overlap_poe_cur(cp_visa_id igs_pe_visa.visa_id%TYPE,
157: cp_issue_date igs_pe_visa.visa_issue_date%TYPE,

Line 164: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

160: FROM igs_pe_visit_histry
161: WHERE visa_id = cp_visa_id AND
162: (visit_start_date < cp_issue_date OR visit_end_date > cp_expiry_date+30);
163:
164: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
165: l_exp_date igs_pe_passport.passport_expiry_date%TYPE;
166: l_count NUMBER(1);
167:
168: BEGIN