DBA Data[Home] [Help]

APPS.PAY_CA_RL1_AMEND_MAG dependencies on HR_GENERAL

Line 1068: SUBSTR(hr_general.decode_lookup(

1064: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1065: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
1066:
1067: tab_transmitter(lProvince) := '' ||
1068: SUBSTR(hr_general.decode_lookup(
1069: 'CA_PROVINCE',l_address_line),1,20) || '
' || EOL;
1070:
1071: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
1072:

Line 1980: SUBSTR(hr_general.decode_lookup(

1976: IF l_emp_province IS NULL OR
1977: l_emp_province <> ' ' THEN
1978: IF l_country = 'CA' THEN
1979: tab_employee(lProvince) := '' ||
1980: SUBSTR(hr_general.decode_lookup(
1981: 'CA_PROVINCE',l_emp_province),1,20) || '
' || EOL;
1982: ELSIF l_country = 'US' THEN
1983: tab_employee(lProvince) := '' || l_emp_province || '' || EOL;
1984: ELSE

Line 3346: SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',

3342: 'CAEOY_RL1_EMPLOYER_PROVINCE');
3343:
3344: IF l_address_line IS NOT NULL THEN
3345: tab_employer(lProvince) := '' ||
3346: SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
3347: l_address_line),1,20) || '
' || EOL;
3348: ELSE
3349: tab_employer(lProvince) := NULL;
3350: END IF;

Line 3514: l_see_attached := hr_general.decode_lookup('PAY_CA_LABELS'

3510: l_boxo1 :=NULL;
3511: l_boxo2 :=NULL;
3512: l_boxo3 :=NULL;
3513:
3514: l_see_attached := hr_general.decode_lookup('PAY_CA_LABELS'
3515: ,'SEE_ATTACHED');
3516: hr_utility.trace('l_see_attached = '||l_see_attached);
3517: SELECT
3518: fnd_global.local_chr(13) || fnd_global.local_chr(10)