APPS.IGS_PE_PASSPORT_PKG dependencies on IGS_PE_VISA

Line 132: FROM IGS_PE_VISA vis

128: CURSOR get_count_exp_dt(p_passport_id igs_pe_passport.passport_id%TYPE,
129: p_passport_expiry_date igs_pe_passport.passport_expiry_date%TYPE)
130: IS
131: SELECT visa_issue_date
132: FROM IGS_PE_VISA vis
133: WHERE passport_id = p_passport_id
134: AND visa_issue_date > p_passport_expiry_date ;
135:
136: l_date igs_pe_visa.visa_issue_date%TYPE;

Line 136: l_date igs_pe_visa.visa_issue_date%TYPE;

132: FROM IGS_PE_VISA vis
133: WHERE passport_id = p_passport_id
134: AND visa_issue_date > p_passport_expiry_date ;
135:
136: l_date igs_pe_visa.visa_issue_date%TYPE;
137:
138: BEGIN
139: OPEN get_count_exp_dt(new_references.passport_id,new_references.passport_expiry_date);
140: FETCH get_count_exp_dt INTO l_date;

Line 223: igs_pe_visa_pkg.get_fk_igs_pe_passport (

219: || (reverse chronological order - newest change first)
220: */
221: BEGIN
222:
223: igs_pe_visa_pkg.get_fk_igs_pe_passport (
224: old_references.passport_id
225: );
226:
227: END check_child_existance;