APPS.PAY_CA_RL2_MAG dependencies on HR_GENERAL

Line 1071: convert_special_char(SUBSTR(hr_general.decode_lookup(

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

Line 2847: convert_special_char(SUBSTR(hr_general.decode_lookup(

2843: l_emp_province <> ' ' THEN
2844:
2845: IF l_country = 'CA' THEN
2846: tab_employee(lProvince) := '' ||
2847: convert_special_char(SUBSTR(hr_general.decode_lookup(
2848: 'CA_PROVINCE',l_emp_province),1,20)) || '' || EOL;
2849: l_full_empaddr := l_full_empaddr ||' '||convert_special_char(l_emp_province);
2850:
2851:

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

4871:
4872: IF ( l_address_line IS NOT NULL AND
4873: l_address_line <> ' ' ) THEN
4874: tab_employer(lProvince) := '' ||
4875: convert_special_char(SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
4876: l_address_line),1,20)) || '' || EOL;
4877: ELSE
4878: tab_employer(lProvince) := NULL;
4879: END IF;