APPS.PAY_CA_RL1_MAG dependencies on HR_GENERAL

Line 806: SUBSTR(hr_general.decode_lookup(

802: l_address_line := pay_ca_archive_utils.get_archive_value(l_context1,
803: 'CAEOY_RL1_TRANSMITTER_PROVINCE');
804:
805: tab_transmitter(lProvince) := '' ||
806: SUBSTR(hr_general.decode_lookup(
807: 'CA_PROVINCE',l_address_line),1,20) || '' || EOL;
808:
809: hr_utility.trace('tab_transmitter(lProvince) = ' || tab_transmitter(lProvince));
810:

Line 1606: SUBSTR(hr_general.decode_lookup(

1602: IF l_emp_province IS NULL OR
1603: l_emp_province <> ' ' THEN
1604: IF l_country = 'CA' THEN
1605: tab_employee(lProvince) := '' ||
1606: SUBSTR(hr_general.decode_lookup(
1607: 'CA_PROVINCE',l_emp_province),1,20) || '' || EOL;
1608: ELSIF l_country = 'US' THEN
1609: tab_employee(lProvince) := '' || l_emp_province || '' || EOL;
1610: ELSE

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

4282: 'CAEOY_RL1_EMPLOYER_PROVINCE');
4283:
4284: IF l_address_line IS NOT NULL THEN
4285: tab_employer(lProvince) := '' ||
4286: SUBSTR(hr_general.decode_lookup( 'CA_PROVINCE',
4287: l_address_line),1,20) || '' || EOL;
4288: ELSE
4289: tab_employer(lProvince) := NULL;
4290: END IF;

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

4450: l_boxo1 :=NULL;
4451: l_boxo2 :=NULL;
4452: l_boxo3 :=NULL;
4453:
4454: l_see_attached := hr_general.decode_lookup('PAY_CA_LABELS'
4455: ,'SEE_ATTACHED');
4456: hr_utility.trace('l_see_attached = '||l_see_attached);
4457: SELECT
4458: fnd_global.local_chr(13) || fnd_global.local_chr(10)