eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_PERSON dependencies on PER_ADDRESSES

Line 167: g_prim_address_line_1 per_addresses.address_line1%TYPE;

163: g_per_attr_10 per_all_people_f.attribute10%TYPE;
164: --
165: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
166: --
167: g_prim_address_line_1 per_addresses.address_line1%TYPE;
168: g_prim_address_line_2 per_addresses.address_line2%TYPE;
169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;

Line 168: g_prim_address_line_2 per_addresses.address_line2%TYPE;

164: --
165: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
166: --
167: g_prim_address_line_1 per_addresses.address_line1%TYPE;
168: g_prim_address_line_2 per_addresses.address_line2%TYPE;
169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;

Line 169: g_prim_address_line_3 per_addresses.address_line3%TYPE;

165: -- g_work_telephone per_all_people_f.work_telephone%TYPE;
166: --
167: g_prim_address_line_1 per_addresses.address_line1%TYPE;
168: g_prim_address_line_2 per_addresses.address_line2%TYPE;
169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;

Line 170: g_prim_city per_addresses.town_or_city%TYPE;

166: --
167: g_prim_address_line_1 per_addresses.address_line1%TYPE;
168: g_prim_address_line_2 per_addresses.address_line2%TYPE;
169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;

Line 171: g_prim_state per_addresses.REGION_2%TYPE;

167: g_prim_address_line_1 per_addresses.address_line1%TYPE;
168: g_prim_address_line_2 per_addresses.address_line2%TYPE;
169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;

Line 172: g_prim_state_ansi per_addresses.REGION_2%TYPE;

168: g_prim_address_line_2 per_addresses.address_line2%TYPE;
169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;

Line 173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;

169: g_prim_address_line_3 per_addresses.address_line3%TYPE;
170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;

Line 174: g_prim_country per_addresses.COUNTRY%TYPE;

170: g_prim_city per_addresses.town_or_city%TYPE;
171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;

Line 175: g_prim_county per_addresses.region_1%TYPE;

171: g_prim_state per_addresses.REGION_2%TYPE;
172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;

Line 176: g_prim_region_3 per_addresses.region_3%TYPE;

172: g_prim_state_ansi per_addresses.REGION_2%TYPE;
173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
180: g_addr_last_update_login per_addresses.last_update_login%TYPE;

Line 177: g_prim_address_date per_addresses.date_from%TYPE;

173: g_prim_postal_code per_addresses.POSTAL_CODE%TYPE;
174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
180: g_addr_last_update_login per_addresses.last_update_login%TYPE;
181: g_addr_created_by per_addresses.created_by%TYPE;

Line 178: g_addr_last_update_date per_addresses.last_update_date%TYPE;

174: g_prim_country per_addresses.COUNTRY%TYPE;
175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
180: g_addr_last_update_login per_addresses.last_update_login%TYPE;
181: g_addr_created_by per_addresses.created_by%TYPE;
182: g_addr_creation_date per_addresses.creation_date%TYPE;

Line 179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;

175: g_prim_county per_addresses.region_1%TYPE;
176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
180: g_addr_last_update_login per_addresses.last_update_login%TYPE;
181: g_addr_created_by per_addresses.created_by%TYPE;
182: g_addr_creation_date per_addresses.creation_date%TYPE;
183: g_prim_addr_service_area ben_svc_area_f.name%TYPE;

Line 180: g_addr_last_update_login per_addresses.last_update_login%TYPE;

176: g_prim_region_3 per_addresses.region_3%TYPE;
177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
180: g_addr_last_update_login per_addresses.last_update_login%TYPE;
181: g_addr_created_by per_addresses.created_by%TYPE;
182: g_addr_creation_date per_addresses.creation_date%TYPE;
183: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
184: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;

Line 181: g_addr_created_by per_addresses.created_by%TYPE;

177: g_prim_address_date per_addresses.date_from%TYPE;
178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
180: g_addr_last_update_login per_addresses.last_update_login%TYPE;
181: g_addr_created_by per_addresses.created_by%TYPE;
182: g_addr_creation_date per_addresses.creation_date%TYPE;
183: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
184: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
185: --

Line 182: g_addr_creation_date per_addresses.creation_date%TYPE;

178: g_addr_last_update_date per_addresses.last_update_date%TYPE;
179: g_addr_last_updated_by per_addresses.last_updated_by%TYPE;
180: g_addr_last_update_login per_addresses.last_update_login%TYPE;
181: g_addr_created_by per_addresses.created_by%TYPE;
182: g_addr_creation_date per_addresses.creation_date%TYPE;
183: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
184: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
185: --
186: g_mail_address_line_1 per_addresses.address_line1%TYPE;

Line 186: g_mail_address_line_1 per_addresses.address_line1%TYPE;

182: g_addr_creation_date per_addresses.creation_date%TYPE;
183: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
184: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
185: --
186: g_mail_address_line_1 per_addresses.address_line1%TYPE;
187: g_mail_address_line_2 per_addresses.address_line2%TYPE;
188: g_mail_address_line_3 per_addresses.address_line3%TYPE;
189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;

Line 187: g_mail_address_line_2 per_addresses.address_line2%TYPE;

183: g_prim_addr_service_area ben_svc_area_f.name%TYPE;
184: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
185: --
186: g_mail_address_line_1 per_addresses.address_line1%TYPE;
187: g_mail_address_line_2 per_addresses.address_line2%TYPE;
188: g_mail_address_line_3 per_addresses.address_line3%TYPE;
189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;

Line 188: g_mail_address_line_3 per_addresses.address_line3%TYPE;

184: g_prim_addr_sva_id ben_svc_area_f.svc_area_id%TYPE;
185: --
186: g_mail_address_line_1 per_addresses.address_line1%TYPE;
187: g_mail_address_line_2 per_addresses.address_line2%TYPE;
188: g_mail_address_line_3 per_addresses.address_line3%TYPE;
189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;

Line 189: g_mail_city per_addresses.town_or_city%TYPE;

185: --
186: g_mail_address_line_1 per_addresses.address_line1%TYPE;
187: g_mail_address_line_2 per_addresses.address_line2%TYPE;
188: g_mail_address_line_3 per_addresses.address_line3%TYPE;
189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;

Line 190: g_mail_state per_addresses.REGION_2%TYPE;

186: g_mail_address_line_1 per_addresses.address_line1%TYPE;
187: g_mail_address_line_2 per_addresses.address_line2%TYPE;
188: g_mail_address_line_3 per_addresses.address_line3%TYPE;
189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;
194: g_mail_county per_addresses.region_1%TYPE;

Line 191: g_mail_state_ansi per_addresses.REGION_2%TYPE;

187: g_mail_address_line_2 per_addresses.address_line2%TYPE;
188: g_mail_address_line_3 per_addresses.address_line3%TYPE;
189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;
194: g_mail_county per_addresses.region_1%TYPE;
195: g_mail_region_3 per_addresses.region_3%TYPE;

Line 192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;

188: g_mail_address_line_3 per_addresses.address_line3%TYPE;
189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;
194: g_mail_county per_addresses.region_1%TYPE;
195: g_mail_region_3 per_addresses.region_3%TYPE;
196: g_mail_address_date per_addresses.date_from%TYPE;

Line 193: g_mail_country per_addresses.COUNTRY%TYPE;

189: g_mail_city per_addresses.town_or_city%TYPE;
190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;
194: g_mail_county per_addresses.region_1%TYPE;
195: g_mail_region_3 per_addresses.region_3%TYPE;
196: g_mail_address_date per_addresses.date_from%TYPE;
197: --

Line 194: g_mail_county per_addresses.region_1%TYPE;

190: g_mail_state per_addresses.REGION_2%TYPE;
191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;
194: g_mail_county per_addresses.region_1%TYPE;
195: g_mail_region_3 per_addresses.region_3%TYPE;
196: g_mail_address_date per_addresses.date_from%TYPE;
197: --
198: g_phone_home per_phones.phone_number%TYPE;

Line 195: g_mail_region_3 per_addresses.region_3%TYPE;

191: g_mail_state_ansi per_addresses.REGION_2%TYPE;
192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;
194: g_mail_county per_addresses.region_1%TYPE;
195: g_mail_region_3 per_addresses.region_3%TYPE;
196: g_mail_address_date per_addresses.date_from%TYPE;
197: --
198: g_phone_home per_phones.phone_number%TYPE;
199: g_phone_work per_phones.phone_number%TYPE;

Line 196: g_mail_address_date per_addresses.date_from%TYPE;

192: g_mail_postal_code per_addresses.POSTAL_CODE%TYPE;
193: g_mail_country per_addresses.COUNTRY%TYPE;
194: g_mail_county per_addresses.region_1%TYPE;
195: g_mail_region_3 per_addresses.region_3%TYPE;
196: g_mail_address_date per_addresses.date_from%TYPE;
197: --
198: g_phone_home per_phones.phone_number%TYPE;
199: g_phone_work per_phones.phone_number%TYPE;
200: g_phone_fax per_phones.phone_number%TYPE;

Line 597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;

593: g_dpnt_known_as per_all_people_f.known_as%TYPE;
594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;

Line 598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;

594: g_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;

Line 599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;

595: g_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
603: g_dpnt_prim_country per_addresses.country%TYPE;

Line 600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;

596: g_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
603: g_dpnt_prim_country per_addresses.country%TYPE;
604: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;

Line 601: g_dpnt_prim_state per_addresses.region_2%TYPE;

597: g_dpnt_prim_address1 per_addresses.address_line1%TYPE;
598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
603: g_dpnt_prim_country per_addresses.country%TYPE;
604: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
605: g_dpnt_prim_region per_addresses.region_3%TYPE;

Line 602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;

598: g_dpnt_prim_address2 per_addresses.address_line2%TYPE;
599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
603: g_dpnt_prim_country per_addresses.country%TYPE;
604: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
605: g_dpnt_prim_region per_addresses.region_3%TYPE;
606: g_dpnt_home_phone per_phones.phone_number%TYPE;

Line 603: g_dpnt_prim_country per_addresses.country%TYPE;

599: g_dpnt_prim_address3 per_addresses.address_line3%TYPE;
600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
603: g_dpnt_prim_country per_addresses.country%TYPE;
604: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
605: g_dpnt_prim_region per_addresses.region_3%TYPE;
606: g_dpnt_home_phone per_phones.phone_number%TYPE;
607: g_dpnt_fax per_phones.phone_number%TYPE;

Line 604: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;

600: g_dpnt_prim_city per_addresses.town_or_city%TYPE;
601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
603: g_dpnt_prim_country per_addresses.country%TYPE;
604: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
605: g_dpnt_prim_region per_addresses.region_3%TYPE;
606: g_dpnt_home_phone per_phones.phone_number%TYPE;
607: g_dpnt_fax per_phones.phone_number%TYPE;
608: g_dpnt_mobile per_phones.phone_number%TYPE;

Line 605: g_dpnt_prim_region per_addresses.region_3%TYPE;

601: g_dpnt_prim_state per_addresses.region_2%TYPE;
602: g_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
603: g_dpnt_prim_country per_addresses.country%TYPE;
604: g_dpnt_prim_effect_date per_addresses.date_from%TYPE;
605: g_dpnt_prim_region per_addresses.region_3%TYPE;
606: g_dpnt_home_phone per_phones.phone_number%TYPE;
607: g_dpnt_fax per_phones.phone_number%TYPE;
608: g_dpnt_mobile per_phones.phone_number%TYPE;
609: g_dpnt_work_phone per_phones.phone_number%TYPE;

Line 643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;

639: g_elig_dpnt_known_as per_all_people_f.known_as%TYPE;
640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;

Line 644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;

640: g_elig_dpnt_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;

Line 645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;

641: g_elig_dpnt_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
649: g_elig_dpnt_prim_country per_addresses.country%TYPE;

Line 646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;

642: g_elig_dpnt_prev_last_name per_all_people_f.last_name%TYPE;
643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
649: g_elig_dpnt_prim_country per_addresses.country%TYPE;
650: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;

Line 647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;

643: g_elig_dpnt_prim_address1 per_addresses.address_line1%TYPE;
644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
649: g_elig_dpnt_prim_country per_addresses.country%TYPE;
650: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
651: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;

Line 648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;

644: g_elig_dpnt_prim_address2 per_addresses.address_line2%TYPE;
645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
649: g_elig_dpnt_prim_country per_addresses.country%TYPE;
650: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
651: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
652: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;

Line 649: g_elig_dpnt_prim_country per_addresses.country%TYPE;

645: g_elig_dpnt_prim_address3 per_addresses.address_line3%TYPE;
646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
649: g_elig_dpnt_prim_country per_addresses.country%TYPE;
650: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
651: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
652: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
653: g_elig_dpnt_fax per_phones.phone_number%TYPE;

Line 650: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;

646: g_elig_dpnt_prim_city per_addresses.town_or_city%TYPE;
647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
649: g_elig_dpnt_prim_country per_addresses.country%TYPE;
650: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
651: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
652: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
653: g_elig_dpnt_fax per_phones.phone_number%TYPE;
654: g_elig_dpnt_mobile per_phones.phone_number%TYPE;

Line 651: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;

647: g_elig_dpnt_prim_state per_addresses.region_2%TYPE;
648: g_elig_dpnt_prim_postal_code per_addresses.postal_code%TYPE;
649: g_elig_dpnt_prim_country per_addresses.country%TYPE;
650: g_elig_dpnt_prim_effect_date per_addresses.date_from%TYPE;
651: g_elig_dpnt_prim_region per_addresses.region_3%TYPE;
652: g_elig_dpnt_home_phone per_phones.phone_number%TYPE;
653: g_elig_dpnt_fax per_phones.phone_number%TYPE;
654: g_elig_dpnt_mobile per_phones.phone_number%TYPE;
655: g_elig_dpnt_work_phone per_phones.phone_number%TYPE;

Line 681: g_contact_prim_address1 per_addresses.address_line1%TYPE;

677: g_contact_known_as per_all_people_f.known_as%TYPE;
678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;

Line 682: g_contact_prim_address2 per_addresses.address_line2%TYPE;

678: g_contact_pre_name_adjunct per_all_people_f.pre_name_adjunct%TYPE;
679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;

Line 683: g_contact_prim_address3 per_addresses.address_line3%TYPE;

679: g_contact_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
687: g_contact_prim_country per_addresses.country%TYPE;

Line 684: g_contact_prim_city per_addresses.town_or_city%TYPE;

680: g_contact_prev_last_name per_all_people_f.last_name%TYPE;
681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
687: g_contact_prim_country per_addresses.country%TYPE;
688: g_contact_prim_effect_date per_addresses.date_from%TYPE;

Line 685: g_contact_prim_state per_addresses.region_2%TYPE;

681: g_contact_prim_address1 per_addresses.address_line1%TYPE;
682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
687: g_contact_prim_country per_addresses.country%TYPE;
688: g_contact_prim_effect_date per_addresses.date_from%TYPE;
689: g_contact_prim_region per_addresses.region_3%TYPE;

Line 686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;

682: g_contact_prim_address2 per_addresses.address_line2%TYPE;
683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
687: g_contact_prim_country per_addresses.country%TYPE;
688: g_contact_prim_effect_date per_addresses.date_from%TYPE;
689: g_contact_prim_region per_addresses.region_3%TYPE;
690: g_contact_home_phone per_phones.phone_number%TYPE;

Line 687: g_contact_prim_country per_addresses.country%TYPE;

683: g_contact_prim_address3 per_addresses.address_line3%TYPE;
684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
687: g_contact_prim_country per_addresses.country%TYPE;
688: g_contact_prim_effect_date per_addresses.date_from%TYPE;
689: g_contact_prim_region per_addresses.region_3%TYPE;
690: g_contact_home_phone per_phones.phone_number%TYPE;
691: g_contact_fax per_phones.phone_number%TYPE;

Line 688: g_contact_prim_effect_date per_addresses.date_from%TYPE;

684: g_contact_prim_city per_addresses.town_or_city%TYPE;
685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
687: g_contact_prim_country per_addresses.country%TYPE;
688: g_contact_prim_effect_date per_addresses.date_from%TYPE;
689: g_contact_prim_region per_addresses.region_3%TYPE;
690: g_contact_home_phone per_phones.phone_number%TYPE;
691: g_contact_fax per_phones.phone_number%TYPE;
692: g_contact_mobile per_phones.phone_number%TYPE;

Line 689: g_contact_prim_region per_addresses.region_3%TYPE;

685: g_contact_prim_state per_addresses.region_2%TYPE;
686: g_contact_prim_postal_code per_addresses.postal_code%TYPE;
687: g_contact_prim_country per_addresses.country%TYPE;
688: g_contact_prim_effect_date per_addresses.date_from%TYPE;
689: g_contact_prim_region per_addresses.region_3%TYPE;
690: g_contact_home_phone per_phones.phone_number%TYPE;
691: g_contact_fax per_phones.phone_number%TYPE;
692: g_contact_mobile per_phones.phone_number%TYPE;
693: g_contact_work_phone per_phones.phone_number%TYPE;

Line 729: g_cm_addr_line1 per_addresses.address_line1%type;

725: g_cm_prtt_enrt_actn_id ben_per_cm_f.prtt_enrt_actn_id%TYPE;
726: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
727: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
728: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
729: g_cm_addr_line1 per_addresses.address_line1%type;
730: g_cm_addr_line2 per_addresses.address_line2%type;
731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;

Line 730: g_cm_addr_line2 per_addresses.address_line2%type;

726: g_cm_trgr_proc_name ben_cm_trgr.proc_cd%type;
727: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
728: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
729: g_cm_addr_line1 per_addresses.address_line1%type;
730: g_cm_addr_line2 per_addresses.address_line2%type;
731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;

Line 731: g_cm_addr_line3 per_addresses.address_line3%type;

727: g_cm_trgr_proc_dt ben_per_cm_trgr_f.effective_start_date%type;
728: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
729: g_cm_addr_line1 per_addresses.address_line1%type;
730: g_cm_addr_line2 per_addresses.address_line2%type;
731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;

Line 732: g_cm_city per_addresses.town_or_city%type;

728: g_cm_address_id ben_per_cm_prvdd_f.address_id%type;
729: g_cm_addr_line1 per_addresses.address_line1%type;
730: g_cm_addr_line2 per_addresses.address_line2%type;
731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;

Line 733: g_cm_state per_addresses.region_2%type;

729: g_cm_addr_line1 per_addresses.address_line1%type;
730: g_cm_addr_line2 per_addresses.address_line2%type;
731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;

Line 734: g_cm_postal_code per_addresses.postal_code%TYPE;

730: g_cm_addr_line2 per_addresses.address_line2%type;
731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;

Line 735: g_cm_country per_addresses.country%type;

731: g_cm_addr_line3 per_addresses.address_line3%type;
732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;

Line 736: g_cm_county per_addresses.region_1%type;

732: g_cm_city per_addresses.town_or_city%type;
733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;

Line 737: g_cm_region_3 per_addresses.region_3%type;

733: g_cm_state per_addresses.region_2%type;
734: g_cm_postal_code per_addresses.postal_code%TYPE;
735: g_cm_country per_addresses.country%type;
736: g_cm_county per_addresses.region_1%type;
737: g_cm_region_3 per_addresses.region_3%type;
738: g_cm_dlvry_instn_txt ben_per_cm_prvdd_f.dlvry_instn_txt%type;
739: g_cm_inspn_rqd_flag ben_per_cm_prvdd_f.inspn_rqd_flag%type;
740: g_cm_to_be_sent_dt ben_per_cm_prvdd_f.to_be_sent_dt%type;
741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;

Line 745: g_cm_address_date per_addresses.date_from%type;

741: g_cm_prvdd_eff_dt ben_per_cm_prvdd_f.effective_start_date%type;
742: g_cm_sent_dt ben_per_cm_prvdd_f.sent_dt%type;
743: g_cm_last_update_date ben_per_cm_f.last_update_date%TYPE;
744: g_cm_pvdd_last_update_date ben_per_cm_prvdd_f.last_update_date%type;
745: g_cm_address_date per_addresses.date_from%type;
746: --
747: g_ppr_name ben_prmry_care_prvdr_f.name%type;
748: g_ppr_ident ben_prmry_care_prvdr_f.ext_ident%type;
749: g_ppr_typ ben_prmry_care_prvdr_f.prmry_care_prvdr_typ_cd%type;

Line 983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;

979: g_bnf_known_as per_all_people_f.known_as%TYPE;
980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;

Line 984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;

980: g_bnf_nationality per_all_people_f.nationality%TYPE;
981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;

Line 985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;

981: g_bnf_tobacco_usage per_all_people_f.uses_tobacco_flag%TYPE;
982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;

Line 986: g_bnf_prim_city per_addresses.town_or_city%TYPE;

982: g_bnf_language per_all_people_f.correspondence_language%TYPE;
983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;

Line 987: g_bnf_prim_state per_addresses.region_2%TYPE;

983: g_bnf_prim_address1 per_addresses.address_line1%TYPE;
984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;

Line 988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;

984: g_bnf_prim_address2 per_addresses.address_line2%TYPE;
985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;

Line 989: g_bnf_prim_country per_addresses.country%TYPE;

985: g_bnf_prim_address3 per_addresses.address_line3%TYPE;
986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;

Line 990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;

986: g_bnf_prim_city per_addresses.town_or_city%TYPE;
987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;

Line 991: g_bnf_prim_region per_addresses.region_3%TYPE;

987: g_bnf_prim_state per_addresses.region_2%TYPE;
988: g_bnf_prim_postal_code per_addresses.postal_code%TYPE;
989: g_bnf_prim_country per_addresses.country%TYPE;
990: g_bnf_prim_effect_date per_addresses.date_from%TYPE;
991: g_bnf_prim_region per_addresses.region_3%TYPE;
992: g_bnf_gender per_all_people_f.sex%TYPE;
993: g_bnf_date_of_birth per_all_people_f.date_of_birth%TYPE;
994: g_bnf_marital_status per_all_people_f.marital_status%TYPE;
995: g_bnf_disabled_flag per_all_people_f.registered_disabled_flag%TYPE;