APPS.IGS_EN_GEN_004 dependencies on IGS_PE_PERS_NOTE

Line 154: FROM IGS_PE_PERS_NOTE pn

150: (iv.visa_expiry_date IS NULL OR
151: iv.visa_expiry_date > p_effective_dt);
152: CURSOR c_pn IS
153: SELECT 'x'
154: FROM IGS_PE_PERS_NOTE pn
155: WHERE pn.person_id = p_person_id;
156: --modified the cursor for the performance bug 3693713
157: --this cursor is used to check statistics record which is created with person record
158: CURSOR c_ps IS