APPS.PAY_CA_RL1_CAN_MAG dependencies on HR_GENERAL

Line 1009: SUBSTR(hr_general.decode_lookup(

1005: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
1006: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
1007:
1008: tab_transmitter(lProvince) := '' ||
1009: SUBSTR(hr_general.decode_lookup(
1010: 'CA_PROVINCE',l_address_line),1,20) || '' || EOL;
1011:
1012: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
1013:

Line 1878: SUBSTR(hr_general.decode_lookup(

1874: IF l_emp_province IS NULL OR
1875: l_emp_province <> ' ' THEN
1876: IF l_country = 'CA' THEN
1877: tab_employee(lProvince) := '' ||
1878: SUBSTR(hr_general.decode_lookup(
1879: 'CA_PROVINCE',l_emp_province),1,20) || '' || EOL;
1880: ELSIF l_country = 'US' THEN
1881: tab_employee(lProvince) := '' || l_emp_province || '' || EOL;
1882: ELSE

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

3219: 'CAEOY_RL1_EMPLOYER_PROVINCE');
3220:
3221: IF l_address_line IS NOT NULL THEN
3222: tab_employer(lProvince) := '' ||
3223: SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
3224: l_address_line),1,20) || '' || EOL;
3225: ELSE
3226: tab_employer(lProvince) := NULL;
3227: END IF;