APPS.CSE_PROJ_ITEM_IN_SRV_PKG dependencies on HZ_LOCATIONS

Line 47: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN

43: debug(' location_id : '||p_location_id);
44:
45: IF p_location_type_code IN ('INVENTORY', 'INTERNAL_SITE') THEN
46: l_location_table := 'HR_LOCATIONS';
47: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
48: BEGIN
49: SELECT 'Y' INTO l_hz_or_hr
50: FROM hz_locations
51: WHERE location_id = p_location_id;

Line 50: FROM hz_locations

46: l_location_table := 'HR_LOCATIONS';
47: ELSIF p_location_type_code = 'HZ_LOCATIONS' THEN
48: BEGIN
49: SELECT 'Y' INTO l_hz_or_hr
50: FROM hz_locations
51: WHERE location_id = p_location_id;
52: l_location_table := 'HZ_LOCATIONS';
53: EXCEPTION
54: WHEN no_data_found THEN

Line 52: l_location_table := 'HZ_LOCATIONS';

48: BEGIN
49: SELECT 'Y' INTO l_hz_or_hr
50: FROM hz_locations
51: WHERE location_id = p_location_id;
52: l_location_table := 'HZ_LOCATIONS';
53: EXCEPTION
54: WHEN no_data_found THEN
55: l_location_table := 'HR_LOCATIONS';
56: END;

Line 338: l_location_type_code := 'HZ_LOCATIONS';

334: x_hz_location_id => l_location_id,
335: x_Return_Status => l_return_status,
336: x_Error_Message => l_error_message );
337:
338: l_location_type_code := 'HZ_LOCATIONS';
339:
340: END IF;
341:
342: get_fa_location_id(