Line 179: select hrl.country from hr_locations hrl
175: and p_effective_date between asg.effective_start_date
176: and asg.effective_end_date;
177: --
178: cursor csr_get_location(p_location_id number) is 179: select hrl.country from hr_locations hrl 180: where hrl.location_id = p_location_id;
181: --
182: Begin
183: --