194: FROM IGS_PE_PERS_NOTE
195: WHERE person_id = p_person_id;
196: CURSOR c_ps IS
197: SELECT coun.person_id
198: FROM IGS_PE_EIT coun,
199: HZ_CITIZENSHIP cz,
200: HZ_PERSON_LANGUAGE lang,
201: IGS_PE_EIT state,
202: IGS_PE_VOTE_INFO_ALL voter,
197: SELECT coun.person_id
198: FROM IGS_PE_EIT coun,
199: HZ_CITIZENSHIP cz,
200: HZ_PERSON_LANGUAGE lang,
201: IGS_PE_EIT state,
202: IGS_PE_VOTE_INFO_ALL voter,
203: IGS_PE_INCOME_TAX_ALL itax
204: WHERE coun.INFORMATION_TYPE = 'PE_STAT_RES_COUNTRY'
205: AND coun.person_id = p_person_id