DBA Data[Home] [Help]

APPS.GHR_SF52_POST_UPDATE dependencies on HR_GENERAL

Line 425: p_employee_dept_or_agency := hr_general.decode_lookup

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);

Line 487: p_from_agency_desc := hr_general.decode_lookup

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);

Line 515: p_employee_dept_or_agency := hr_general.decode_lookup

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