421: hr_utility.set_location(l_proc,20);
422:
423: -- Employee_dept_or_agency
424: if p_agency_code is not null then
425: p_employee_dept_or_agency := hr_general.decode_lookup
426: (p_lookup_type => 'GHR_US_AGENCY_CODE',
427: p_lookup_code => p_agency_code
428: );
429: hr_utility.set_location(l_proc, 30);
483: p_from_agency_code := l_from_agency_code;
484: hr_utility.set_location(l_proc,50);
485:
486: if l_from_agency_code is not null then
487: p_from_agency_desc := hr_general.decode_lookup
488: (p_lookup_type => 'GHR_US_AGENCY_CODE',
489: p_lookup_code => l_from_agency_code
490: );
491: hr_utility.set_location(l_proc, 55);
511: p_to_office_symbol := p_parei.rei_information6; -- Bug 3547836
512: END LOOP;
513: -- Start of Bug 3547836
514: IF p_agency_code IS NOT NULL THEN
515: p_employee_dept_or_agency := hr_general.decode_lookup
516: (p_lookup_type => 'GHR_US_AGENCY_CODE',
517: p_lookup_code => p_agency_code
518: );
519: ELSE