162: g_per_attr_10 per_all_people_f.attribute10%TYPE;
163: --
164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
165: --
166: g_prim_address_line_1 per_addresses.address_line1%TYPE;
167: g_prim_address_line_2 per_addresses.address_line2%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
163: --
164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
165: --
166: g_prim_address_line_1 per_addresses.address_line1%TYPE;
167: g_prim_address_line_2 per_addresses.address_line2%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
164: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
165: --
166: g_prim_address_line_1 per_addresses.address_line1%TYPE;
167: g_prim_address_line_2 per_addresses.address_line2%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
165: --
166: g_prim_address_line_1 per_addresses.address_line1%TYPE;
167: g_prim_address_line_2 per_addresses.address_line2%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
166: g_prim_address_line_1 per_addresses.address_line1%TYPE;
167: g_prim_address_line_2 per_addresses.address_line2%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
167: g_prim_address_line_2 per_addresses.address_line2%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
168: g_prim_address_line_3 per_addresses.address_line3%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
169: g_prim_city per_addresses.town_or_city%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
170: g_prim_state per_addresses.REGION_2%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
171: g_prim_state_ansi per_addresses.REGION_2%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
179: g_addr_last_update_login per_addresses.last_update_login%TYPE;
172: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
179: g_addr_last_update_login per_addresses.last_update_login%TYPE;
180: g_addr_created_by per_addresses.created_by%TYPE;
173: g_prim_country per_addresses.COUNTRY%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
179: g_addr_last_update_login per_addresses.last_update_login%TYPE;
180: g_addr_created_by per_addresses.created_by%TYPE;
181: g_addr_creation_date per_addresses.creation_date%TYPE;
174: g_prim_county per_addresses.region_1%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
179: g_addr_last_update_login per_addresses.last_update_login%TYPE;
180: g_addr_created_by per_addresses.created_by%TYPE;
181: g_addr_creation_date per_addresses.creation_date%TYPE;
182: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
175: g_prim_region_3 per_addresses.region_3%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
179: g_addr_last_update_login per_addresses.last_update_login%TYPE;
180: g_addr_created_by per_addresses.created_by%TYPE;
181: g_addr_creation_date per_addresses.creation_date%TYPE;
182: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
183: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
176: g_prim_address_date per_addresses.date_from%TYPE;
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
179: g_addr_last_update_login per_addresses.last_update_login%TYPE;
180: g_addr_created_by per_addresses.created_by%TYPE;
181: g_addr_creation_date per_addresses.creation_date%TYPE;
182: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
183: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
184: --
177: g_addr_last_update_date per_addresses.last_update_date%TYPE;
178: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
179: g_addr_last_update_login per_addresses.last_update_login%TYPE;
180: g_addr_created_by per_addresses.created_by%TYPE;
181: g_addr_creation_date per_addresses.creation_date%TYPE;
182: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
183: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
184: --
185: g_mail_address_line_1 per_addresses.address_line1%TYPE;
181: g_addr_creation_date per_addresses.creation_date%TYPE;
182: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
183: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
184: --
185: g_mail_address_line_1 per_addresses.address_line1%TYPE;
186: g_mail_address_line_2 per_addresses.address_line2%TYPE;
187: g_mail_address_line_3 per_addresses.address_line3%TYPE;
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
182: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
183: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
184: --
185: g_mail_address_line_1 per_addresses.address_line1%TYPE;
186: g_mail_address_line_2 per_addresses.address_line2%TYPE;
187: g_mail_address_line_3 per_addresses.address_line3%TYPE;
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
183: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
184: --
185: g_mail_address_line_1 per_addresses.address_line1%TYPE;
186: g_mail_address_line_2 per_addresses.address_line2%TYPE;
187: g_mail_address_line_3 per_addresses.address_line3%TYPE;
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
184: --
185: g_mail_address_line_1 per_addresses.address_line1%TYPE;
186: g_mail_address_line_2 per_addresses.address_line2%TYPE;
187: g_mail_address_line_3 per_addresses.address_line3%TYPE;
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
192: g_mail_county per_addresses.region_1%TYPE;
185: g_mail_address_line_1 per_addresses.address_line1%TYPE;
186: g_mail_address_line_2 per_addresses.address_line2%TYPE;
187: g_mail_address_line_3 per_addresses.address_line3%TYPE;
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
192: g_mail_county per_addresses.region_1%TYPE;
193: g_mail_region_3 per_addresses.region_3%TYPE;
186: g_mail_address_line_2 per_addresses.address_line2%TYPE;
187: g_mail_address_line_3 per_addresses.address_line3%TYPE;
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
192: g_mail_county per_addresses.region_1%TYPE;
193: g_mail_region_3 per_addresses.region_3%TYPE;
194: g_mail_address_date per_addresses.date_from%TYPE;
187: g_mail_address_line_3 per_addresses.address_line3%TYPE;
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
192: g_mail_county per_addresses.region_1%TYPE;
193: g_mail_region_3 per_addresses.region_3%TYPE;
194: g_mail_address_date per_addresses.date_from%TYPE;
195: --
188: g_mail_city per_addresses.town_or_city%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
192: g_mail_county per_addresses.region_1%TYPE;
193: g_mail_region_3 per_addresses.region_3%TYPE;
194: g_mail_address_date per_addresses.date_from%TYPE;
195: --
196: g_phone_home per_phones.phone_number%TYPE;
189: g_mail_state per_addresses.REGION_2%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
192: g_mail_county per_addresses.region_1%TYPE;
193: g_mail_region_3 per_addresses.region_3%TYPE;
194: g_mail_address_date per_addresses.date_from%TYPE;
195: --
196: g_phone_home per_phones.phone_number%TYPE;
197: g_phone_work per_phones.phone_number%TYPE;
190: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
191: g_mail_country per_addresses.COUNTRY%TYPE;
192: g_mail_county per_addresses.region_1%TYPE;
193: g_mail_region_3 per_addresses.region_3%TYPE;
194: g_mail_address_date per_addresses.date_from%TYPE;
195: --
196: g_phone_home per_phones.phone_number%TYPE;
197: g_phone_work per_phones.phone_number%TYPE;
198: g_phone_fax per_phones.phone_number%TYPE;
590: g_dpnt_known_as per_all_people_f.known_as%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
591: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
592: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
593: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
594: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
595: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
596: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
604: g_dpnt_fax per_phones.phone_number%TYPE;
597: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
604: g_dpnt_fax per_phones.phone_number%TYPE;
605: g_dpnt_mobile per_phones.phone_number%TYPE;
598: g_dpnt_prim_state per_addresses.region_2%TYPE;
599: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
600: g_dpnt_prim_country per_addresses.country%TYPE;
601: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
602: g_dpnt_prim_region per_addresses.region_3%TYPE;
603: g_dpnt_home_phone per_phones.phone_number%TYPE;
604: g_dpnt_fax per_phones.phone_number%TYPE;
605: g_dpnt_mobile per_phones.phone_number%TYPE;
606: g_dpnt_work_phone per_phones.phone_number%TYPE;
636: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
637: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
638: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
639: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
640: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
641: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
642: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
650: g_elig_dpnt_fax per_phones.phone_number%TYPE;
643: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
650: g_elig_dpnt_fax per_phones.phone_number%TYPE;
651: g_elig_dpnt_mobile per_phones.phone_number%TYPE;
644: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
645: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
646: g_elig_dpnt_prim_country per_addresses.country%TYPE;
647: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
648: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
649: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
650: g_elig_dpnt_fax per_phones.phone_number%TYPE;
651: g_elig_dpnt_mobile per_phones.phone_number%TYPE;
652: g_elig_dpnt_work_phone per_phones.phone_number%TYPE;
674: g_contact_known_as per_all_people_f.known_as%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
675: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
676: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
677: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
678: g_contact_prim_address1 per_addresses.address_line1%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
679: g_contact_prim_address2 per_addresses.address_line2%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
680: g_contact_prim_address3 per_addresses.address_line3%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
688: g_contact_fax per_phones.phone_number%TYPE;
681: g_contact_prim_city per_addresses.town_or_city%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
688: g_contact_fax per_phones.phone_number%TYPE;
689: g_contact_mobile per_phones.phone_number%TYPE;
682: g_contact_prim_state per_addresses.region_2%TYPE;
683: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
684: g_contact_prim_country per_addresses.country%TYPE;
685: g_contact_prim_effect_date per_addresses.date_from%TYPE;
686: g_contact_prim_region per_addresses.region_3%TYPE;
687: g_contact_home_phone per_phones.phone_number%TYPE;
688: g_contact_fax per_phones.phone_number%TYPE;
689: g_contact_mobile per_phones.phone_number%TYPE;
690: g_contact_work_phone per_phones.phone_number%TYPE;
722: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;
723: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
724: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
725: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
726: g_cm_addr_line1 per_addresses.address_line1%type;
727: g_cm_addr_line2 per_addresses.address_line2%type;
728: g_cm_addr_line3 per_addresses.address_line3%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
723: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
724: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
725: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
726: g_cm_addr_line1 per_addresses.address_line1%type;
727: g_cm_addr_line2 per_addresses.address_line2%type;
728: g_cm_addr_line3 per_addresses.address_line3%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
724: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
725: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
726: g_cm_addr_line1 per_addresses.address_line1%type;
727: g_cm_addr_line2 per_addresses.address_line2%type;
728: g_cm_addr_line3 per_addresses.address_line3%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
732: g_cm_country per_addresses.country%type;
725: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
726: g_cm_addr_line1 per_addresses.address_line1%type;
727: g_cm_addr_line2 per_addresses.address_line2%type;
728: g_cm_addr_line3 per_addresses.address_line3%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
732: g_cm_country per_addresses.country%type;
733: g_cm_county per_addresses.region_1%type;
726: g_cm_addr_line1 per_addresses.address_line1%type;
727: g_cm_addr_line2 per_addresses.address_line2%type;
728: g_cm_addr_line3 per_addresses.address_line3%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
732: g_cm_country per_addresses.country%type;
733: g_cm_county per_addresses.region_1%type;
734: g_cm_region_3 per_addresses.region_3%type;
727: g_cm_addr_line2 per_addresses.address_line2%type;
728: g_cm_addr_line3 per_addresses.address_line3%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
732: g_cm_country per_addresses.country%type;
733: g_cm_county per_addresses.region_1%type;
734: g_cm_region_3 per_addresses.region_3%type;
735: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
728: g_cm_addr_line3 per_addresses.address_line3%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
732: g_cm_country per_addresses.country%type;
733: g_cm_county per_addresses.region_1%type;
734: g_cm_region_3 per_addresses.region_3%type;
735: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
736: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
729: g_cm_city per_addresses.town_or_city%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
732: g_cm_country per_addresses.country%type;
733: g_cm_county per_addresses.region_1%type;
734: g_cm_region_3 per_addresses.region_3%type;
735: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
736: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
737: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
730: g_cm_state per_addresses.region_2%type;
731: g_cm_postal_code per_addresses.postal_code%TYPE;
732: g_cm_country per_addresses.country%type;
733: g_cm_county per_addresses.region_1%type;
734: g_cm_region_3 per_addresses.region_3%type;
735: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
736: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
737: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
738: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
738: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
739: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
740: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;
741: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;
742: g_cm_address_date per_addresses.date_from%type;
743: --
744: g_ppr_name ben_prmry_care_prvdr_f.name%type;
745: g_ppr_ident ben_prmry_care_prvdr_f.ext_ident%type;
746: g_ppr_typ ben_prmry_care_prvdr_f.prmry_care_prvdr_typ_cd%type;
976: g_bnf_known_as per_all_people_f.known_as%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
977: g_bnf_nationality per_all_people_f.nationality%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
978: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
979: g_bnf_language per_all_people_f.correspondence_language%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
980: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
981: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
982: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
983: g_bnf_prim_city per_addresses.town_or_city%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
984: g_bnf_prim_state per_addresses.region_2%TYPE;
985: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
986: g_bnf_prim_country per_addresses.country%TYPE;
987: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
988: g_bnf_prim_region per_addresses.region_3%TYPE;
989: g_bnf_gender per_all_people_f.sex%TYPE;
990: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
991: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
992: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;