APPS.HXC_TPD_END dependencies on HR_LOCATIONS

Line 1803: FROM hr_locations

1799: END IF;
1800:
1801: SELECT location_code
1802: INTO l_value
1803: FROM hr_locations
1804: WHERE location_id = p_locn_id
1805: AND ROWNUM < 2 ;
1806:
1807: g_locn_name(TO_CHAR(p_locn_id)) := l_value;