1389: FROM
1390: (SELECT hrl.address_line_1 || ', '
1391: || decode(hrl.address_line_2, null, '', hrl.address_line_2||', ')
1392: || decode(hrl.address_line_3, null, '', hrl.address_line_3||', ')
1393: || decode(hr_general.decode_lookup(hrl.country||'_PROVINCE',hrl.town_or_city ),
1394: NULL, decode(hrl.town_or_city, null, '', hrl.town_or_city ||', '),
1395: hr_general.decode_lookup(hrl.country||'_PROVINCE',hrl.town_or_city ) || ', ')
1396: AS part1,
1397: nvl(decode(hrl.region_1,
1391: || decode(hrl.address_line_2, null, '', hrl.address_line_2||', ')
1392: || decode(hrl.address_line_3, null, '', hrl.address_line_3||', ')
1393: || decode(hr_general.decode_lookup(hrl.country||'_PROVINCE',hrl.town_or_city ),
1394: NULL, decode(hrl.town_or_city, null, '', hrl.town_or_city ||', '),
1395: hr_general.decode_lookup(hrl.country||'_PROVINCE',hrl.town_or_city ) || ', ')
1396: AS part1,
1397: nvl(decode(hrl.region_1,
1398: null, hrl.region_2,
1399: decode(flv1.meaning,