APPS.IGS_AD_GEN_007 dependencies on IGS_PE_PERSON_ADDR

Line 179: FROM IGS_PE_PERSON_ADDR pa,

175: WHERE pe_person_id = p_person_id ;
176:
177: CURSOR c_person IS
178: SELECT person_id
179: FROM IGS_PE_PERSON_ADDR pa,
180: IGS_CO_ADDR_TYPE adt
181: WHERE pa.person_id = p_person_id AND
182: adt.addr_type = pa.addr_type AND
183: pa.correspondence_ind = 'Y';