APPS.XLE_LEGAL_ADDRESS_SWI dependencies on HR_LOCATIONS

Line 458: l_legal_address_flag hr_locations.legal_address_flag%TYPE;

454: (p_location_id in number
455: ) is
456: -- variables
457: l_object_version_number number;
458: l_legal_address_flag hr_locations.legal_address_flag%TYPE;
459: l_return_status varchar(1);
460: l_temp_ovn number(9);
461: l_proc CONSTANT varchar2(72) := g_package ||'enable_legal_address_flag';
462: Begin

Line 466: from hr_locations

462: Begin
463:
464: select object_version_number, legal_address_flag
465: into l_object_version_number, l_legal_address_flag
466: from hr_locations
467: where location_id = p_location_id;
468:
469: if(l_legal_address_flag is null) then
470: l_legal_address_flag := 'N';