APPS.IGS_PE_VISA_PKG dependencies on IGS_PE_VISIT_HISTRY

Line 160: FROM igs_pe_visit_histry

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,
158: cp_expiry_date igs_pe_visa.visa_expiry_date%TYPE) IS
159: SELECT 1
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;

Line 298: igs_pe_visit_histry_pkg.get_fk_igs_pe_visa (

294: || (reverse chronological order - newest change first)
295: */
296: BEGIN
297:
298: igs_pe_visit_histry_pkg.get_fk_igs_pe_visa (
299: old_references.visa_id
300: );
301:
302: END check_child_existance;