APPS.IGS_GE_GEN_002 dependencies on IGS_PE_PERSON_ADDR_V

Line 270: FROM IGS_PE_PERSON_ADDR_V padv

266: -- # 2382471 Added for Country ,State and Zip Code
267: padv.state padv_state,
268: padv.postal_code padv_postal_code,
269: padv.country_desc padv_country_desc
270: FROM IGS_PE_PERSON_ADDR_V padv
271: WHERE padv.person_id = cp_person_id AND
272: padv.addr_type = cp_addr_type;
273:
274: CURSOR initial_name_cur(cp_person_id hz_parties.party_id%TYPE) IS