APPS.PAY_CA_RL1_MAG dependencies on HR_GENERAL

Line 1005: SUBSTR(hr_general.decode_lookup(

1001: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1002: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
1003:
1004: tab_transmitter(lProvince) := '' ||
1005: SUBSTR(hr_general.decode_lookup(
1006: 'CA_PROVINCE',l_address_line),1,20) || '' || EOL;
1007:
1008: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
1009:

Line 2166: SUBSTR(hr_general.decode_lookup(

2162: IF l_emp_province IS NULL OR
2163: l_emp_province <> ' ' THEN
2164: IF l_country = 'CA' THEN
2165: tab_employee(lProvince) := '' ||
2166: SUBSTR(hr_general.decode_lookup(
2167: 'CA_PROVINCE',l_emp_province),1,20) || '' || EOL;
2168: ELSIF l_country = 'US' THEN
2169: tab_employee(lProvince) := '' || l_emp_province || '' || EOL;
2170: ELSE

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

4319: 'CAEOY_RL1_EMPLOYER_PROVINCE');
4320:
4321: IF l_address_line IS NOT NULL THEN
4322: tab_employer(lProvince) := '' ||
4323: SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
4324: l_address_line),1,20) || '' || EOL;
4325: ELSE
4326: tab_employer(lProvince) := NULL;
4327: END IF;

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

4489: l_boxo1 :=NULL;
4490: l_boxo2 :=NULL;
4491: l_boxo3 :=NULL;
4492:
4493: l_see_attached := hr_general.decode_lookup('PAY_CA_LABELS'
4494: ,'SEE_ATTACHED');
4495: hr_utility.trace('l_see_attached = '||l_see_attached);
4496: SELECT
4497: fnd_global.local_chr(13) || fnd_global.local_chr(10)