APPS.IGR_VAL_EAP dependencies on IGS_PE_PERSON_ADDR

Line 283: FROM IGS_PE_PERSON_ADDR pa

279: DECLARE
280: v_ret_val BOOLEAN DEFAULT TRUE;
281: CURSOR c_pa_adt IS
282: SELECT 'X'
283: FROM IGS_PE_PERSON_ADDR pa
284: WHERE pa.person_id = p_person_id AND
285: pa.correspondence_ind = 'Y' AND
286: (pa.status = 'A' AND
287: SYSDATE BETWEEN NVL(pa.start_dt,SYSDATE) AND NVL(pa.end_dt,SYSDATE));