APPS.PAY_CA_RL2_CAN_MAG dependencies on HR_GENERAL

Line 1067: convert_special_char(SUBSTR(hr_general.decode_lookup(

1063:
1064: IF (l_trans_province IS NOT NULL AND
1065: l_trans_province <> ' ') THEN
1066: tab_transmitter(lProvince) := '' ||
1067: convert_special_char(SUBSTR(hr_general.decode_lookup(
1068: 'CA_PROVINCE',l_trans_province),1,20)) || '' || EOL;
1069: ELSE
1070: tab_transmitter(lProvince) := NULL;
1071: END IF;

Line 1951: convert_special_char(SUBSTR(hr_general.decode_lookup(

1947: l_emp_province <> ' ' THEN
1948:
1949: IF l_country = 'CA' THEN
1950: tab_employee(lProvince) := '' ||
1951: convert_special_char(SUBSTR(hr_general.decode_lookup(
1952: 'CA_PROVINCE',l_emp_province),1,20)) || '' || EOL;
1953: l_full_empaddr := l_full_empaddr ||' '||convert_special_char(l_emp_province);
1954:
1955:

Line 2848: convert_special_char(SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',

2844:
2845: IF ( l_address_line IS NOT NULL AND
2846: l_address_line <> ' ' ) THEN
2847: tab_employer(lProvince) := '' ||
2848: convert_special_char(SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
2849: l_address_line),1,20)) || '' || EOL;
2850: ELSE
2851: tab_employer(lProvince) := NULL;
2852: END IF;