101: and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
102: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
103: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
104: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
105: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
106: = nvl (hr_general.get_business_group_id, -99)
107: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
108: ;
109:
102: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
103: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
104: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
105: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
106: = nvl (hr_general.get_business_group_id, -99)
107: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
108: ;
109:
110:
138: and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
139: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
140: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
141: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
142: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
143: = nvl (hr_general.get_business_group_id, -99)
144: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
145: ;
146:
139: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
140: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
141: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
142: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
143: = nvl (hr_general.get_business_group_id, -99)
144: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
145: ;
146:
147:
174: and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
175: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
176: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
177: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
178: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
179: = nvl (hr_general.get_business_group_id, -99)
180: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
181: ;
182:
175: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
176: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
177: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
178: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
179: = nvl (hr_general.get_business_group_id, -99)
180: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
181: ;
182:
183: