955:
956: IF (l_trans_province IS NOT NULL AND
957: l_trans_province <> ' ') THEN
958: tab_transmitter(lProvince) := '
959: convert_special_char(SUBSTR(hr_general.decode_lookup(
960: 'CA_PROVINCE',l_trans_province),1,20)) || '
961: ELSE
962: tab_transmitter(lProvince) := NULL;
963: END IF;
1994: l_emp_province <> ' ' THEN
1995:
1996: IF l_country = 'CA' THEN
1997: tab_employee(lProvince) := '
1998: convert_special_char(SUBSTR(hr_general.decode_lookup(
1999: 'CA_PROVINCE',l_emp_province),1,20)) || '
2000: l_full_empaddr := l_full_empaddr ||' '||convert_special_char(l_emp_province);
2001:
2002:
3247:
3248: IF ( l_address_line IS NOT NULL AND
3249: l_address_line <> ' ' ) THEN
3250: tab_employer(lProvince) := '
3251: convert_special_char(SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
3252: l_address_line),1,20)) || '
3253: ELSE
3254: tab_employer(lProvince) := NULL;
3255: END IF;