APPS.IGF_SE_GEN_001 dependencies on IGS_PE_VISIT_HISTRY

Line 317: FROM igs_pe_visa a,igs_pe_visit_histry b

313: WHERE person_id = cv_person_id;
314:
315: CURSOR c_visa (cv_person_id hz_parties.party_id%TYPE ) IS
316: SELECT a.visa_type,a.visa_category,a.visa_number,a.visa_expiry_date, b.visit_start_date entry_date
317: FROM igs_pe_visa a,igs_pe_visit_histry b
318: WHERE a.person_id = cv_person_id
319: AND NVL(a.visa_expiry_date,SYSDATE) >= SYSDATE
320: AND a.visa_id = b.visa_id
321: ORDER BY a.visa_expiry_date DESC;