APPS.IGS_EN_GEN_004 dependencies on IGS_PE_VISA

Line 148: FROM IGS_PE_VISA iv

144: FROM IGS_PE_PERS_DISABLTY
145: WHERE person_id = p_person_id;
146: CURSOR c_iv IS
147: SELECT 'x'
148: FROM IGS_PE_VISA iv
149: WHERE iv.person_id = p_person_id AND
150: (iv.visa_expiry_date IS NULL OR
151: iv.visa_expiry_date > p_effective_dt);
152: CURSOR c_pn IS