[Home] [Help]
APPS.IGF_AW_LI_IMPORT dependencies on IGS_PE_VISA
Line 887: FROM igs_pe_visa a,
883: a.visa_category,
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