APPS.IGF_AW_LI_IMPORT dependencies on IGS_PE_VISIT_HISTRY

Line 888: igs_pe_visit_histry b

884: a.visa_number,
885: a.visa_expiry_date,
886: b.visit_start_date entry_date
887: FROM igs_pe_visa a,
888: igs_pe_visit_histry b
889: WHERE a.person_id = cv_person_id
890: AND NVL(a.visa_expiry_date,SYSDATE) >= SYSDATE
891: AND a.visa_id = b.visa_id
892: ORDER BY a.visa_expiry_date DESC;