APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on HR_LOCATIONS

Line 136: FROM hr_locations

132: AND l_pvt_RQH_rec.ship_to_location_id <> FND_API.G_MISS_NUM) THEN
133: BEGIN
134: SELECT count(location_id)
135: INTO l_count
136: FROM hr_locations
137: WHERE location_id = l_pvt_RQH_Rec.ship_to_location_id;
138: IF (l_count <= 0) THEN
139: FND_MESSAGE.SET_NAME ('PAY', 'HR_52034_DPF_LOCATION_EXIST');
140: FND_MSG_PUB.ADD;