DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on HR_GENERAL

Line 959: convert_special_char(SUBSTR(hr_general.decode_lookup(

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)) || '
' || EOL;
961: ELSE
962: tab_transmitter(lProvince) := NULL;
963: END IF;

Line 1998: convert_special_char(SUBSTR(hr_general.decode_lookup(

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)) || '
' || EOL;
2000: l_full_empaddr := l_full_empaddr ||' '||convert_special_char(l_emp_province);
2001:
2002:

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

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)) || '
' || EOL;
3253: ELSE
3254: tab_employer(lProvince) := NULL;
3255: END IF;