1062:
1063: IF (l_trans_province IS NOT NULL AND
1064: l_trans_province <> ' ') THEN
1065: tab_transmitter(lProvince) := '
1066: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup(
1067: 'CA_PROVINCE',l_trans_province),1,20)) || '
1068: ELSE
1069: tab_transmitter(lProvince) := NULL;
1070: END IF;
1971: l_emp_province <> ' ' THEN
1972:
1973: IF l_country = 'CA' THEN
1974: tab_employee(lProvince) := '
1975: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup(
1976: 'CA_PROVINCE',l_emp_province),1,20)) || '
1977: l_full_empaddr := l_full_empaddr ||' '||pay_ca_rl2_mag.convert_special_char(l_emp_province);
1978:
1979:
3000:
3001: IF ( l_province IS NOT NULL AND
3002: l_province <> ' ' ) THEN
3003: tab_employer(lProvince) := '
3004: pay_ca_rl2_mag.convert_special_char(SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
3005: l_province),1,20)) || '
3006: ELSE
3007: tab_employer(lProvince) := NULL;
3008: END IF;